http://www.sqlservercentral.com/blogs/glennberry/2011/10/18/october-2011-sql-server-2008-diagnostic-information-queries/

Printed 2014/07/28 10:57PM

October 2011 SQL Server 2008 Diagnostic Information Queries

By GlennBerry, 2011/10/18

Since Microsoft has been so busy releasing Cumulative Updates for both SQL Server 2008 and SQL Server 2008 R2 over the past few days, I thought it would be a good time to release a new version of my SQL Server 2008 Diagnostic Information Queries. Most of these queries will work on either SQL Server 2008 or SQL Server 2008 R2, but a few (which are noted in the comments) only work on SQL Server 2008 R2 SP1 or later.

That is yet another reason to read the instructions, and run each query one at a time, rather than running them all in one batch. Most of the queries also require VIEW SERVER STATE permission.

The top half of the queries are instance level, so it does not matter what database you are pointing to when you run them, but the second half of the queries are database specific, which means you don’t want to be pointing at the master database when you run them.

Please let me know what you think of these queries. Thanks!



Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.