Thursday, March 15, 2007

What would like to see in a Statspack report?

One of my frustrations with the supplied statspack report is that it provides too much information which makes it hard to see the relevant information needed to diagnose problems. I do wish that there was at least a 132 character wide version...

You have seen some of my recent 'customizations' on this blog or on my site. I am currently working on scripts that will compare statistics/events between two (or more) time ranges and generate information about sql statements with multiple execution plans and compare statement performance across time ranges as well.

So, my dear blog readers, what data would you like to see in a statspack report? Respond with your ideas, suggestions, thoughts and I'll see what I can do about putting together the sql to generate that data and post it to my website (www.optimaldba.com) for all to use.

0 comments:

Followers

Blog Archive

About Me