SQL Server 2012 Diagnostic Information Queries (December 2011)

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.

This entry was posted in SQL Server 2012, SQL Server Denali and tagged , . Bookmark the permalink.

3 Responses to SQL Server 2012 Diagnostic Information Queries (December 2011)

  1. Brian R says:

    I was hoping against hope that more of these would run on SQL Azure, since they upgraded it to run SQL 2012. No such luck. It’s basically the same as before – the sproc performance queries (top by reads, writes, etc) work and basically nothing else. Some day, maybe, hopefully.

  2. Pingback: Something for the Weekend – SQL Server Links 23/12/11

  3. Pingback: SQL Server 2008 Diagnostic Information Queries (December 2011) | Glenn Berry's SQL Server Performance

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s