Mel, I have found that for 'us' keeping less than 100k Help Tickets or Tasks in those forms keeps performance at an acceptable level. You have to remember that all workflow is affected by the number of records in the form and keep in mind any table fields that are refreshed.
We generally keep 13 months of or closed records. Since we upgraded to v7.0.1P3 last year I was excited about the 'archive' option. In the last month I've used it on HTs, Tasks and email messages. For us it appears to require a huge amount of disk space for the copy/delete option. That needs to be planned for and it was greater than 1 for 1 which is logical since another table is now holding the same record. For us it was quite a bit more than that infact we nearly brought the server down. I only archive in the lowest of production hours (night) when minimal users are on the system. I was also notified yesterday that it is not recommended to archive system email messages, there is some unusal result related to it. Sorry did not get more info. I found the actual archiving to go fairly quick, was doing about 70k records both times. I liked the fact I didn't have to manually delete the records afterwards. hth, Susan ShopperTrak On Wed, Mar 26, 2008 at 8:28 AM, Melanie Snayer <[EMAIL PROTECTED]> wrote: > ** 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 <http://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 <http://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" > > > > __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"
