Thad: Since I was "on the clock" as a contractor when I built those indexes, I'll have to ask the customer if they mind my sharing the work product. Technically, the IP belongs to them. I'll shoot an email off, and if I get a reply, I'll post the info here on the list.
Anyone else who may have done the same work in-house might be able to share their recommendations... anyone... Bueller... anyone? --Phil ________________________________ From: Thad K Esser <[email protected]> To: [email protected] Sent: Monday, December 22, 2008 5:42:58 PM Subject: Indexes on DSL (was Re: Archiving SLM:Measurement) ** 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. * __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"
