• 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?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/