SQL Server 2008 Diagnostic Information Queries (Dec 2010)

I have been quite the slacker (by my usual standards) for blogging over the past few weeks, but my excuse is that I have been working on finishing my book for SimpleTalk Publishing.

Here is the December 2010 version of my SQL Server 2008 Diagnostic Information Queries. I have made quite a few changes to this version compared to previous versions. One thing I did was to add an OPTION (RECOMPILE) query hint to each query to make sure these queries don’t get cached (since I had noticed that a few of them were being cached as ad-hoc queries).

I have also added a blank Excel query results spreadsheet, with labeled tabs that correspond to each query in the script. The idea is that you can run each query, and then right-click on the top left corner of the results grid in SQL Server Management Studio, and select “Copy with Headers”, and then paste the results into the appropriate tab in the spreadsheet. That way you can pretty quickly save the results in a pretty portable format that you can easily send to someone (like me) for interpretation.

The two files are hosted in Dropbox, which seems like a better idea than pasting the script directly into my blog post. Let me know what you think!

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

4 Responses to SQL Server 2008 Diagnostic Information Queries (Dec 2010)

  1. Glenn Wilson says:

    You should start a CodePlex project with the Queries and Allow people to add to them.

  2. Dominique Quilgars says:

    Hello Glenn,

    your queries are very helpful at each time I need to obtain information from Servers.
    This time I can’t download them, I have an error from dropbox.
    I’m very interested by your new book.

    Thanks for offer to us your practice.

  3. Pingback: SQL Server Blogs and news for the week 17/12/10 | John Sansom - SQL Server DBA in the UK

  4. Pingback: Weekly Challenges – 12/17/10 « SQL Feather and Quill

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