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
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
@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
: 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
]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
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+
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
] 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
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
...@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
: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
11 matches
Mail list logo
