I found that it would take me about 2 hours to archive about 5,000 records using the copy and delete. I would recommend archiving more that once a day in smaller chunks. Using AR Utilities, you can count records to determine if the archiving is still running. Be careful in your scheduling because you cannot start and archive before the last is finished, which may have led to the crash.
Hope this helps. Mark ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vijayalakshmi Paulraj Sent: Thursday, December 11, 2008 7:52 AM To: [email protected] Subject: Re: Performance Issue In Archiving the data Just a small tip. The fields (columns) you use to specify the Archive qualification should be indexed so to avoid full table scan before the archiving starts. Thanks&Regards, Vijayalakshmi Paulraj ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Vyom Labs - ITSM Support Sent: Thursday, December 11, 2008 3:45 PM To: [email protected] Subject: Performance Issue In Archiving the data Hello Everyone ... We are in very wired situation right now. We are using Remedy 7.0.0 with ITSM Suits. We are facing problem in archiving. Our user complaining about slow performance of system everyday. If i am not wrong it's could be solve if we archive current HPD tickets. currently we have, more than 34,00,000 incident record in HPD:HelpDesk. We tried to archive with qualification which has near around 60,000 record. But our UAT server had crash while arching. Same risk of arching we can not take on production. We have following H/w configuration. Application server: 16 GB RAM, Sun 4 u (dual core - 4 CPU) OS - Solaris 10 Database (remote) - 10g Web server (remote) - tomact 5.5 Per day Incident are around 30,000. So we have decided to archive everyday. Qualification would be like this, so system archive only 2 days record before 3 months. So everyday we will archive around 50,000 Record. We want to know, How much time it will take? .. please any suggestion would be welcome ... __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ------------------------------------------------------------------------ -------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ------------------------------------------------------------------------ -------------------- __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ This e-mail is the property of NaviSite, Inc. It is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential, or otherwise protected from disclosure. Distribution or copying of this e-mail, or the information contained herein, to anyone other than the intended recipient is prohibited. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
