• I'm with Grant here. Time for you to put in some effort so 1. you yourself know and understand is actually running in your production environment, 2. you can explain to at least one other person, i.e. document it, and 3. you can interpret the information you are looking at when all this valuable information is collected.

    This post helped me a ton back in the day. It might be a good start for you: SQL Server Perfmon (Performance Monitor) Best Practices by Brent Ozar December 30, 2006[/url]

    Just keep in mind the date of the article. A lot has happened since then. In SQL 2008 new DMV information is available as is the Extended Event subsystem Grant mentioned.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato