Tag Archives: Diagnostic Queries

September 2011 SQL Server 2008 Instance Level Diagnostic Queries

Posted on September 26, 2011 by Glenn Berry

Since it is late September, I thought it would be a good time to release an updated set of Diagnostic queries that focus completely on SQL Server instance level metrics. These queries go a little deeper into the Instance level … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 6 Comments

September 2011 SQL Server 2008 Diagnostic Queries

Posted on September 20, 2011 by Glenn Berry

Its been a couple of months since I have released an updated version of my SQL Server 2008 Diagnostic Information Queries, so I thought it was about time for a new version. The first half of this set of queries … Continue reading →

Posted in SQL Server 2008, SQL Server 2008 R2 | Tagged , | 6 Comments

March 2011 Version of SQL Server 2005 and 2008 Diagnostic Queries

Posted on March 7, 2011 by Glenn Berry

Another month, and another new version of my SQL Server Diagnostic Information queries for both SQL Server 2005 and SQL Server 2008/2008 R2. I have uploaded the scripts for each version to DropBox (see the links below). There are two … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged , | 7 Comments

Updated SQL 2005 and 2008 Diagnostic Queries

Posted on December 29, 2010 by Glenn Berry

Since it is almost January 2011, I thought I would post the January 2011 versions of the SQL Server 2005 Diagnostic Information Queries and the SQL Server 2008 Diagnostic Information Queries. To go with them are the matching blank results … Continue reading →

Posted in SQL Server 2005, SQL Server 2008, SQL Server 2008 R2 | Tagged , | 9 Comments