SQL Server 2012 Diagnostic Information Queries (March 2013)

Here is the March 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have added some new columns to several of the queries, and improved the formatting of the results to make many of the queries easier to read and interpret.

To go with it is an updated, blank 2012 results spreadsheet, where the tabs in the spreadsheet are labeled and in the same order as the queries. The idea is that you can run these queries one by one, click on the top left square of the results grid, and then right-click and select “Copy with Headers” to select and copy the results of the query and then paste them into the matching tab of the results spreadsheet.

One new feature (since February) is that I have modified the initial comment for these queries to make them work better with Mitch Wheat’s SQLDiagCmd program that is a standalone .NET program to run these queries and automatically capture the results in a nice Excel spreadsheet (which saves you the time and trouble of doing it manually). I recently discovered that Mitch also has a WinForms application that is even easier to use.

Many of these queries only work on SQL Server 2012, although some will work on older versions of SQL Server. If you are using an older version of SQL Server, you should use the version of my diagnostic queries for that version of SQL Server.

You should be aware that both Query 52 and Query 56 could take some time to run, depending on the size of your database and the speed of your hardware and storage subsystem.

As always, I welcome any feedback you may have about these queries.

About these ads
This entry was posted in Diagnostic Queries, SQL Server 2012 and tagged , . Bookmark the permalink.

3 Responses to SQL Server 2012 Diagnostic Information Queries (March 2013)

  1. Pingback: SQL Server – Diagnostic Information Queries (2005/2008/2012) | Alex Souza

  2. Pedro Oliveira says:

    Hi,

    Just noticed that on the SQL2005 queries you have a query to get blocking sessions using sys.dm_exec_requests.
    In 2012 and 2008 you don’t any query for that. Any particularly reason why? Is there another one that does that using a different DMV on 2012 and 2008?

    Thanks,
    Pedro

  3. Pingback: Something for the Weekend - SQL Server Links 08/03/13 • John Sansom

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s