Phil, Any chance you have the list of indexes you added to the DSL or other tuning work you did for it? My first data import was pretty painful. If not, I can work through it, but thought if you had a list handy, it'd save me some time.
Thanks in advance, Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach Phil Murnane <pjmurn...@yahoo.com> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 12/19/2008 11:35 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: Archiving SLM:Measurement ** 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 -- 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___ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"