Hi Susan Thanks so much for this info. What database are you running on and on what platform?
Mel On 3/26/08, Susan Palmer <[EMAIL PROTECTED]> wrote: > > ** 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___ > > > > __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"