Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

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 Redgate 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!


Comments

Posted by Jason Brimhall on 14 December 2010

When will the book be coming out?

Posted by Dukagjin Maloku on 15 December 2010

Thanks! Seems the book will be very interesting!

Leave a Comment

Please register or log in to leave a comment.