May 2011 SQL Server 2008 Diagnostic Information Queries

Since we are in the middle of May 2011, I thought was was time to update my SQL Server 2008 Diagnostic Information Queries. These are very similar to the April 2011 version except for one new query at the end of the set.

You can click on the link above to download the queries from Dropbox. What I always recommend is that you run each query separately, after you read the instructions and comments on how to interpret the results. The first half of the queries focus on your SQL Server instance, while the second half focuses on a specific SQL Server database on that instance. That means you want to make sure you are in the context of the right database when you run the database specific queries (not master).

This set of queries will work on both SQL Server 2008 and SQL Server 2008 R2. There is a separate set of queries available for SQL Server 2005, and a separate set available for SQL Server Denali.

I also recommend that you download the matching query results spreadsheet, so that you can copy and paste the results for each query into it, for later analysis. This makes the results much easier to interpret, and lets you keep a record of changes over time.

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

5 Responses to May 2011 SQL Server 2008 Diagnostic Information Queries

  1. Pingback: What Are You Waiting For? | John Sansom - SQL Server DBA in the UK

  2. Pingback: Something for the Weekend – SQL Server Links 20/05/11 | John Sansom - SQL Server DBA in the UK

  3. Richard Long says:

    I found these queries are helpful.
    1. Do you have these for SQL 2005?
    2. I got a very slow full backup. Normally it took about 3 hours, but today, it took 12+hours. I have Spotlight installed and can see teh CPU,MEM usage are low. No blocking found in activity monitor.
    I suspect that SAN is cuasing the problem. But how can I prove that to my system team? It will be highly ap[preciated if you can pass me some script or method to identify / resolve the issue.

    Thanks.

  4. Pingback: What Are You Waiting For?

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