Since it is nearly March, I will go ahead and jump the gun by a few days and post an updated version of my SQL Server 2008/2008 R2 Diagnostic Queries for March 2012.
For this version, I have added information about the latest SQL Server 2008 R2 Cumulative Updates, added some more interpretation information for many of the queries, and added some new columns to some of the existing queries.
This set of queries is only for SQL Server 2008 or SQL Server 2008 R2. Some of the queries (which are marked), will only work with SQL Server 2008 R2 SP1 since they use DMVs or DMFs that were added in SP1.
As always, I recommend that you run the queries one at a time, after reading the comments and instructions for each query. You should not make any rash decisions based on the results of a single query. Instead, you should gather more information and use your good judgment and experience before you do something like dropping an index.
Filed under: SQL Server 2008 R2 Tagged: DMV Queries