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. -------------------------------------------------------------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
