SQL Server 2005 Diagnostic Information Queries (June 2012)

Here is the latest version of my SQL Server 2005 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. With the SQL Server 2005 version of SQL Server Management Studio (SSMS), you will want to enable the “Copy with Headers” option under Tools, Options,Query Results, SQL Server, Results to Grid in order to be able copy the results with headers

These queries are designed to work on SQL Server 2005, although many of them will also work on newer versions of SQL Server. If you have a newer version of SQL Server you are really better off getting the proper version of these queries. The latest SQL Server 2008 version is here, and the latest SQL Server 2012 version is here.

As always, let me know what you think of these queries.

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

9 Responses to SQL Server 2005 Diagnostic Information Queries (June 2012)

  1. Peter says:

    Hi Glenn, Many thanks for the scripts and the spreadsheet.
    Looks like the SQL Server 2005 Diagnostic Information Queries is pointing to an older copy (Dec 2011).
    Best regards
    Peter

  2. jeroen says:

    the link does not contain the most recent version.

  3. Ranga says:

    Glen, Thanks a lot for your scripts…has helped me a many time to find intresting information. I have one question on the IO stalls: io_stall_read_ms, io_stall_write_ms , what numbers are reasonable.

  4. R says:

    Glenn,
    I simply love your scripts…amazingly helpful…
    thank you for putting this all together.

  5. joenoll says:

    Glenn this is great stuff as always thanks for keeping it up to date.

  6. Pingback: Recompile Option – Yes, No, Maybe? « The SQL Corner

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