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 improved > 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 with > BMC. But as usual I didn't get a proper response. > > > > Thanks & Regards, > > Thivagar Sankaran > > ITIL – 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 for > 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-live. > 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"