Mel,
We're running 7.0.1 with ITSM 6. We instituted archiving a little over a
month ago, it was sorely needed, and it certainly has made a difference.
Since Remedy was put into production back in the summer of 2004, approx
390,000 tickets had been submitted. The amount of tickets had not been a
problem until recently when we began to see performance lags performing
various actions in Remedy. Opening an existing Help Desk ticket from the
Remedy Support console alone was taking anywhere from 1 to 5 seconds
depending on the ticket (API and SQL logs were very helpful here).
We decided to archive all Help Desk tickets with a status of Closed that
were older than 13 months. We considered using Remedy's archiving feature,
but eventually went with Misi Mladoniczky's rrrchive utility. Since our
lab testing indicated that the archiving of an estimated 250,000 tickets
would take about 6 to 7 hours (and slow the system down tremendously), we
decided to archive in chunks of 40,000 which limited the performance pain
to about an hour. We did this for 7 nights in a row. I can tell you that
since, performance has improved tremendously (max time to open an existing
ticket is about a second). Archiving is done nightly now. It takes a
minute to archive the 400 to 500 tickets that meet the archive criteria. I
know that my users are happy.
Joe
Joseph Kasell
Navy Federal Credit Union
Melanie Snayer
<[EMAIL PROTECTED]
MAIL.COM> To
Sent by: "Action [email protected]
Request System cc
discussion
list(ARSList)" Subject
<[EMAIL PROTECTED] Re: BMC Remedy - Copy to Archive
ORG> and Delete from Source
03/26/2008 05:45
AM
Please respond to
[EMAIL PROTECTED]
RG
------=_Part_6872_1105761.1206524742321
Content-Type: text/plain; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hey Thivagar
We are in a 7.01 environment but I'm glad to know that this improved on
performance. Could you perhaps give me a rough indication of the
following information:
- what your database size is
- number of records before the archive
- time taken to save a call before the archive
- number of records after the archive
- time taken to save a call after the archive
Anyone else like to share a bit of their archiving info with me?
Regards
Mel
On 3/26/08, Thivagar Sankaran <[EMAIL PROTECTED]> wrote:
> **
>
> Hi Mel,
>
>
>
> Recently I have archived the data in my 6.3 environment. I have done this
> to improve the performance and I observe the performance has been
improve=
d
> considerably. But the issue was, the Copy to Archive and Delete from
> Source option was not working in my environment. Hence I went for Copy to
> Archive Option and deleted the data manually. I have raised this issue
wi=
th
> BMC. But as usual I didn't get a proper response.
>
>
>
> Thanks & Regards,
>
> Thivagar Sankaran
>
> ITIL =96 Foundataion Certified
>
> Remedy Developer
>
>
> ------------------------------
>
> *From:* Action Request System discussion list(ARSList) [mailto:
> [EMAIL PROTECTED] *On Behalf Of *Melanie Snayer
> *Sent:* Wednesday, March 26, 2008 2:44 PM
> *To:* [email protected]
> *Subject:* BMC Remedy - Copy to Archive and Delete from Source
>
>
>
> **
>
> Hi Listeners
>
>
>
> We're experiencing performance issues especially when submitting
> incidents. Our initial plan was to archive calls that have been closed
fo=
r
> more than 5 years but as a result of the performance issues we're having
=
to
> considering archiving as soon as 1 year and 6 months after having
gone-li=
ve.
> Well, archiving is just one of the options that we have resorted to along
> side the current ongoing perfomance tuning that we're doing.
>
>
>
> Can you guys give me examples of how you may have gone about archiving
> your data? Like what the archiving criteria is and whether your archiving
> was done as a result of performance issue or as standard procedure.
>
>
>
> Thanks
>
> Mel
>
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
> html___
>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
------=_Part_6872_1105761.1206524742321
Content-Type: text/html; charset=WINDOWS-1252
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
**
<div>Hey Thivagar</div>
<div> </div>
<div>We are in a 7.01 environment but I'm glad to know that this
i=
mproved on performance. Could you perhaps give me a rough indication of
the=
following information:</div>
<ul>
<li>what your database size is</li>
<li>number of records before the archive</li>
<li>time taken to save a call before the archive</li>
<li>number of records after the archive</li>
<li>time taken to save a call after the archive</li></ul>
<div>Anyone else like to share a bit of their archiving info with me?</div>
<div> </div>
<div>Regards</div>
<div>Mel</div>
<div> </div>
<div><span class=3D"gmail_quote">On 3/26/08, <b
class=3D"gmail_sendername">=
Thivagar Sankaran</b> <<a href=3D"
mailto:[EMAIL PROTECTED]
m">[EMAIL PROTECTED]</a>> wrote:</span></div>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px
0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">**=20
<div lang=3D"EN-US" vlink=3D"purple" link=3D"blue">
<div>
<div>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial">Hi Mel,</span></font></p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial">Recently I have archived the data
i=
n my 6.3 environment. I have done this to improve the performance and I
obs=
erve the performance has been improved considerably. But the issue was,
the=
</span></font><font face=3D"Arial" color=3D"navy" size=3D"2"><span style=
=3D"FONT-SIZE: 10pt; COLOR: navy; FONT-FAMILY: Arial">Copy to Archive and
D=
elete from Source option was not working in my environment. Hence I went
fo=
r Copy to Archive Option and deleted the data manually. I have raised this
=
issue with BMC. But as usual I didn't get a proper
response.</span></font><=
/p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial">Thanks &
Regards,</span></font>=
</p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial">Thivagar Sankaran</span></font></p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial">ITIL =96 Foundataion
Certified</spa=
n></font></p>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial">Remedy
Developer</span></font></p><=
/div>
<p><font face=3D"Arial" color=3D"navy" size=3D"2"><span
style=3D"FONT-SIZE:=
10pt; COLOR: navy; FONT-FAMILY: Arial"> </span></font></p>
<div>
<div style=3D"TEXT-ALIGN: center" align=3D"center"><font face=3D"Times New
=
Roman" size=3D"3"><span style=3D"FONT-SIZE: 12pt">
<hr align=3D"center" width=3D"100%" size=3D"2">
</span></font></div>
<p><b><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-WEIGHT: bold;
FO=
NT-SIZE: 10pt; FONT-FAMILY: Tahoma">From:</span></font></b><font
face=3D"Ta=
homa" size=3D"2"><span style=3D"FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">
Acti=
on Request System discussion list(ARSList) [mailto:<a onclick=3D"return
top=
.js.OpenExtLink(window,event,this)" href=3D"mailto:[email protected]";
tar=
get=3D"_blank">[email protected]</a>] <b><span style=3D"FONT-WEIGHT:
bold=
">On Behalf Of </span></b>Melanie Snayer<br>
<b><span style=3D"FONT-WEIGHT: bold">Sent:</span></b> Wednesday, March 26,
=
2008 2:44 PM<br><b><span style=3D"FONT-WEIGHT: bold">To:</span></b> <a
oncl=
ick=3D"return top.js.OpenExtLink(window,event,this)" href=3D"
mailto:arslist=
@ARSLIST.ORG" target=3D"_blank">[email protected]</a><br>
<b><span style=3D"FONT-WEIGHT: bold">Subject:</span></b> BMC Remedy - Copy
=
to Archive and Delete from Source</span></font></p></div>
<p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
12pt=
"> </span></font></p>
<p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
12pt=
">** </span></font></p>
<div><span class=3D"e" id=3D"q_118ea6ae8655e334_1">
<div>
<p><font face=3D"Tahoma" color=3D"black" size=3D"2"><span
style=3D"FONT-SIZ=
E: 10pt; COLOR: black; FONT-FAMILY: Tahoma">Hi
Listeners</span></font></p><=
/div>
<div>
<p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
12pt=
"> </span></font></p></div>
<div>
<p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
FONT-FA=
MILY: Tahoma">We're experiencing performance issues
especially&nbs=
p;when submitting incidents. Our initial plan was to archive
call=
s that have been closed for more than 5 years but as a result of the
perfor=
mance issues we're having to considering archiving as soon
as =
;1 year and 6 months after having gone-live. Well, archiving is just one
of=
the options that we have resorted to along side the current ongoing
perfom=
ance tuning that we're doing.</span></font></p>
</div>
<div>
<p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
12pt=
"> </span></font></p></div>
<div>
<p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
FONT-FA=
MILY: Tahoma">Can you guys give me examples of how you may
h=
ave gone about archiving your data? Like what the archiving criteria is
and=
whether your archiving was done as a result of performance
issue =
;or as standard procedure.</span></font></p>
</div>
<div>
<p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
12pt=
"> </span></font></p></div>
<div>
<p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
FONT-FA=
MILY: Tahoma">Thanks</span></font></p></div>
<div>
<p><font face=3D"Tahoma" size=3D"2"><span style=3D"FONT-SIZE: 10pt;
FONT-FA=
MILY: Tahoma">Mel</span></font></p></div></span></div>
<p><font face=3D"Times New Roman" size=3D"3"><span style=3D"FONT-SIZE:
12pt=
">__Platinum Sponsor: <a onclick=3D"return
top.js.OpenExtLink(window,event,=
this)" href=3D"http://www.rmsportal.com/";
target=3D"_blank">www.rmsportal.c=
om</a> ARSlist: "Where the Answers Are" html___
</span></font></p=
>
</div></div>__Platinum Sponsor: <a onclick=3D"return
top.js.OpenExtLink(win=
dow,event,this)" href=3D"http://www.rmsportal.com/";
target=3D"_blank">www.r=
msportal.com</a> ARSlist: "Where the Answers Are" html___ <br
cle=
ar=3D"all">
</blockquote><br>
__Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
html___
------=_Part_6872_1105761.1206524742321--
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
