SQL Diagnostics Queries

macuxpc

I did a search and nothing came up.

Glenn Berry is a SQL MVP and I have been using his "SQL Diagnostics Queries" consistently when troubleshooting NAV/SQL performance issues.

Here is a link to his SQL 2008(R2) Diagnostics Queries, but he also maintains versions for SQL 2005 and 2012: http://sqlserverperformance.wordpress.com/2012/07/03/sql-server-2008-diagnostic-information-queries-july-2012/

I also read Glenn's book on SQL Server hardware - there is a free PDF version available: http://sqlserverperformance.wordpress.com/2011/08/28/sql-server-hardware-choices-made-easy/

Lots of useful scripts....lots of useful info....

stryk

Hi there,

yes, indeed a very ... uhm ... "rich" script providing a lot of information :thumbsup:

But the trouble with THAT MUCH information is, that people have to understand what they get and interpret it correctly :twisted:

macuxpc

stryk wrote:

Hi there,

yes, indeed a very ... uhm ... "rich" script providing a lot of information :thumbsup:

But the trouble with THAT MUCH information is, that people have to understand what they get and interpret it correctly :twisted:

Absolutely - I agree. Just wanted to share this stuff since I find it pretty useful (just like your PTB ).