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 <[email protected]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 12/19/2008 11:35 AM Please respond to [email protected] To [email protected] 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 <[email protected]> To: [email protected] 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 = [email protected] 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"
