Chapter 11 – SQLDiag and PerfStats

Author: Justin Langford

This chapter covers data collection, SQLDiag, and the PerfStats script.

Errata

None found yet, knock on wood!

Downloads

None yet. If there’s anything you’d like to see added here, let us know with a comment.

2 thoughts on “Chapter 11 – SQLDiag and PerfStats”

Mladen Andrijasevic on March 29, 2011 at 10:14 am said:

Do PerfStats and SQLDiag run under SQL S2008 R2 RTM?

I had no problem running PerfStats,SQLDiag and SQL Nexus
under SQL 2008 SP2 but when I try running

StartSQLDiagTrace2008.cmd with SQLDiagPerfStats_Trace2008.XML
under SQL S2008 R2 RTM

I get

2011/03/29 13:24:35.69 SQLDIAG There are no instances of version 10 on this computer

2011/03/29 13:24:35.69 SQLDIAG . Function result: 87. Message: The parameter is incorrect.

Is this a known problem?

Thanks
Harvey Mace on April 5, 2011 at 8:59 am said:

Hi Mladen
this was frustrating me for a while too. I chopped everything out of the .XML file until I found out you have to change ssver from 10 to 10.5 (2008R2 is version 10.5)
Harvey