I think the key is the ApplicationInstanceID in SLM:Measurement being tied to the instanceID of records in HPD:Help Desk.
If the record in HPD:HelpDesk is Resolved or Closed then its instanceID should be found in the SLM:Measurement table in the ApplicatiionInstanceID field. There is probably already a join between HPD:Help Desk and SLM:Measurement using these fields as a link in the system. (Not sure but I think it is HPD:Help Desk_SLA) Thanks Peter Lammey ESPN IT Client Architecture and Automation 860-766-4761 ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of William Rentfrow Sent: Monday, December 22, 2008 10:23 AM To: arslist@ARSLIST.ORG Subject: Re: Archiving SLM:Measurement ** We are going to do that - the Oracle performance guys were being a bit proactive and got to it first :) The bigger issue though is just trying to figure out what to I'm going to break in the SLM Console or other places by archiving these records. I also haven't really yet even looked at this in detail and I'm not sure of a few things. For example, how do I identify in SLM:Measurement which records pertain to a request that has been resolved? I'm sure it's possible - I just have been involved in other things lately. ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Saturday, December 20, 2008 11:08 PM To: arslist@ARSLIST.ORG Subject: Re: Archiving SLM:Measurement ** If the push fields actions are causing table scans, why not index fields referenced in the push fields if qualification queries? 4.5 million records is not so much of a big deal? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org]on Behalf Of William Rentfrow Sent: Friday, December 19, 2008 5:15 PM To: arslist@ARSLIST.ORG Subject: Re: Archiving SLM:Measurement ** We are investigating some changes now - we've also done some tuning via Oracle profiles (and by "we" I mean the dba's....). ________________________________ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Phil Murnane Sent: Friday, December 19, 2008 1:35 PM To: arslist@ARSLIST.ORG 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 On Fri, Dec 19, 2008 at 12:35 PM, William Rentfrow <wrentf...@stratacominc.com<mailto: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<mailto:wrentf...@stratacominc.com> 701-306-6157 C 952-432-0227 O __Platinum Sponsor: www.rmsportal.com<http://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<mailto:hbr4...@gmail.com> LinkedIn Profile = http://www.linkedin.com/in/hbr4270 __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ ________________________________ Please consider the environment before printing this e-mail. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"