SQL Server 2012 Diagnostic Information Queries (June 2012)

Here is the latest version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements, including query numbering and one new query at the end. To go with it is an updated, blank 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.

These queries will work on SQL Server 2012, although some of them will also work on older versions of SQL Server. As always, let me know what you think of these queries.

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

5 Responses to SQL Server 2012 Diagnostic Information Queries (June 2012)

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

  2. Stefan says:

    Excellent queries, which I use frequently. The links to the excel sheet seems to point to the sql2008 version, and the link in the 2008 version points to the sql 2008 queries. Thanks

  3. Pingback: SQL Server 2005 Diagnostic Information Queries (June 2012) | Glenn Berry's SQL Server Performance

  4. Pingback: SQL Server 2005 Diagnostic Information Queries (June 2012) - afrizal.com - TeuGoBlog

  5. Pingback: Replay a T-SQL batch against all databases « spaghettidba

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