MSSQLTips

http://www.mssqltips.com/tip.asp?tip=1863

Ray,

Great tip!  With all of the native (Profiler, DMV's, scripts, etc.) and third party performance tools on the market, why would someone select SQLDIAG as their tool?  Is it for the consolidated information?

Any thoughts on limiting or focusing in on particular data with SQLDIAG?

Do you have any plans on writing additional tips on SQLDIAG to increase awareness and documentation on the tool?

Thank you,
The MSSQLTips Team

My main reason for using SQLDIAG is that by launching a single command you can gather just about everything you need.  I usually start out with scanning the performance counters, looking at the notable queries and any blocking.

As I incorporate my own additional queries I'll add additional tips.

Ray,

OK - Looking forward to those tips!

Thank you,
The MSSQLTips Team