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 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 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 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
Re: Archiving SLM:Measurement
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.commailto: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.commailto:wrentf...@stratacominc.com 701-306-6157 C 952-432-0227 O __Platinum Sponsor: www.rmsportal.comhttp://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.commailto: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
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 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
Re: Indexes on DSL (was Re: Archiving SLM:Measurement)
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 tkes...@regence.com To: arslist@ARSLIST.ORG 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 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. * __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
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 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 No virus found in this outgoing message. Checked by AVG. Version: 7.5.552 / Virus Database: 270.9.19/1859 - Release Date: 12/20/2008 2:34 PM ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Archiving SLM:Measurement
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Archiving SLM:Measurement
William: Sounds like a pretty good solution to me. Just out of curiosity, are you seeing performance problems due to the 4.5M records in SLM:Measurement? --Phil From: William Rentfrow wrentf...@stratacominc.com To: arslist@ARSLIST.ORG Sent: Friday, December 19, 2008 10:35:06 AM Subject: Archiving SLM:Measurement ** 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
Re: Archiving SLM:Measurement
There are some pretty severe Oracle performance problems we had to address - the Push fields if filters that fire to populate the form end up causing many, many table scans. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Phil Murnane Sent: Friday, December 19, 2008 12:44 PM To: arslist@ARSLIST.ORG Subject: Re: Archiving SLM:Measurement ** William: Sounds like a pretty good solution to me. Just out of curiosity, are you seeing performance problems due to the 4.5M records in SLM:Measurement? --Phil From: William Rentfrow wrentf...@stratacominc.com To: arslist@ARSLIST.ORG Sent: Friday, December 19, 2008 10:35:06 AM Subject: Archiving SLM:Measurement ** 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___ __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
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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are
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 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
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 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 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 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___ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: Where the Answers Are