I use it for the alerts, the worst performing, growth, statistics, viewing user processes - it's a very useful tool to have running. Never had to worry about changing the data - view stats is pretty good.

Extracting the worst performing could be easier / better.

• I don't use it for rebuilding indexes or stats.
• I view extract worst performing for optimisation
• I view table growth/ useage of text columns and will look at indexes and sizes on tables
• I view growth stats for databases
• I make use of running processes and the drill down to individual users
• I use the output of the proc cache and stats as well as the memory breakdown
• I look at cpu and io, page life and some of the others.
• I use all the alerts for blocking, deadlocks, cpu, failed jobs, longin running jobs, open trans
• I use the combined alert log for all servers

how's that for a start?

I also have the tool but don't use it as often as I should. Thanks for the advice

_WM

For those of you who have this product, would you buy it again or would you look at another product?  I tried it out and liked it, just wondering what your thoughts are after working with it awhile.

Thanks,

Bart