On Oct 6, 11:33 am, Arun Srini wrote:
> Hi
> We are trying to quantify the impact on the database performance due
> to running queries that query the sysibmadm snapshot views and profile
> whats running in the databse.
>
> All we are trying to do is to collect info on what app is running, how
> much i/o its using, how much bufferpool its using, cost (if its SP
> this is also tough to get), etc for a week in our prod and store it in
> a central table. We'll then group them and try to find the application
> profiles on our database.
> We now are debating if this should be run every 5 mins since it would
> impact the performance.
> Database gurus and experts, please help me quantify how much impact
> this would have on my database.
>
> Thanks
I don't think there would be severe impact on performance if you are
just monitoring what you're talking here. I ever have a set of scripts
doing the same things as you want and then generately report in HTML
format with JPEG chart in a hourly,dayly, weekly or monthly manner.
If you do have enough system resource, IMO, just run it. Take care if
you want collect statement level information though.
>> Stay informed about: impact on database due to running sql snapshots 
FAQ
Search
Profile
Private Messages
Log in
