Since the final RTM release of SQL Server is getting ever closer, I thought it was a good time to release an updated version of my SQL Server 2012 Diagnostic Information Queries. These queries are meant to be used with SQL Server 2012, but many of them will also work with SQL Server 2008 R2 SP1 or later. There are a few breaking changes in some of the DMVs between SQL Server 2008/2008 R2 and SQL Server 2012. Some of the queries in this set will also work with older versions of SQL Server.
The main changes for this version are some additional comments on how to interpret the results of the queries, plus some changes in the order of the queries. There was also some minor cleanup of several of the queries. As always, you will need VIEW SERVER STATE permission to run most of these queries. I recommend that you run them one at a time, after reading the directions and interpretation comments.
Filed under: SQL Server 2012, SQL Server Denali Tagged: DMV, DMV Queries