SQL Diagnostics Queries

macuxpc
macuxpc Member Posts: 16
edited 2012-08-01 in SQL Performance
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....
MacUxPC
Dynamics-NAV.org

Comments

  • stryk
    stryk Member Posts: 645
    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:
    Jörg A. Stryk (MVP - Dynamics NAV)
    NAV/SQL Performance Optimization & Troubleshooting
    STRYK System Improvement
    The Blog - The Book - The Tool
  • macuxpc
    macuxpc Member Posts: 16
    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 :D ).
    MacUxPC
    Dynamics-NAV.org

Categories