SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

Here is the May 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and improvements to several of the existing queries. I have decided to split off this into a separate version just for SQL Server 2008 R2.

To go with it is an updated, blank 2008 R2 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.

Many of these queries only work on SQL Server 2008 R2, although some will work on older versions of SQL Server. A few of the queries also require SQL Server 2008 R2 Service Pack 1 or newer. 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.

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

This entry was posted in SQL Server 2008 R2 and tagged , . Bookmark the permalink.

2 Responses to SQL Server 2008 R2 Diagnostic Information Queries (May 2013)

  1. David Evans says:

    You’re a Legend Glenn. We appreciate your work.

  2. anoospillai says:

    An asset to SQL DBAs, Thank you Glenn..

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 )

Connecting to %s