William: At one customer site, we added some indexes to help those Push Fields If conditions and avoid the table scans. SLM benefits quite a bit from some DB tuning. So does the DSL, but that's another topic. :)
--Phil ________________________________ From: Howard Richter <hbr4...@gmail.com> To: arslist@ARSLIST.ORG Sent: Friday, December 19, 2008 11:53:26 AM Subject: Re: Archiving SLM:Measurement ** Bill, On my past two systems (that had SLM) we trashed anything in the SLM:Measurement, older then 30 days and that was not tied to active ticket. I think we were able to report, but I don't remember from where. hbr On Fri, Dec 19, 2008 at 12:35 PM, William Rentfrow <wrentf...@stratacominc.com> wrote: ** It's Friday and I have some other stuff to finish today so I haven't gotten too far into researching this yet - so I thought I'd ask if anyone else has a solution for this already. Problem: SLM:Measurement is gigantic. We have 240,000 requests in HPD:Help Desk (IM 7.x) and 4,400,000+ SLM:Measurement records. My gut feeling is to just archive off all of the records that are closed and refer the reporting people to that table when they want to run reports; however, I have not yet investigated the ramifications of doing this. Has anyone else? William Rentfrow Principal Consultant, StrataCom Inc. wrentf...@stratacominc.com 701-306-6157 C 952-432-0227 O __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ -- Howard Richter Red Hat Certified Technician CompTIA Linux+ Certified ITIL Foundation Certified E-Mail = hbr4...@gmail.com LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __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"