Hi Joe Thanks so much for this information. Would you perhaps be able to tell me whether there was a delay on saving Help Desk tickets before you archived?
Regards Mel On 3/26/08, Joseph Kasell <[EMAIL PROTECTED]> wrote: > > 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 arslist@ARSLIST.ORG > 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:* arslist@ARSLIST.ORG > > *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:arslist@ARSLIST.ORG" > tar= > get=3D"_blank">arslist@ARSLIST.ORG</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">arslist@ARSLIST.ORG</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" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"