Help with DBCC SQLPERF(USMSTATS)

• Andy Stephenson-354717

  SSC Enthusiast

  Points: 124

  More actions

  January 25, 2007 at 3:51 am

  #153400

  Hi,

  I need some help interpreting the results of DBCC SQLPERF(USMSTATS). I have a job that runs this command all the time while a NetApp snapshot takes place. When the snapshot is taking place, the num_runnable for one of the schedulers hits a massive 8, but the other 3 schedulers at zero. As I understand it, it should num_runnable should be 2 max. What does it all mean? Big question, I know, but I'm not finding much on the net.

  If I may give some background as to why I'm asking: NetApp want me to increase the MAX WORKER THREAD above 255 (which I don't want to) as their SAN backup S/W is failing 10% of the time. I'm trying to capture the number of worker threads when the snapshots run.

  Thanks in advance.

  Andy

• MohammedU

  SSCoach

  Points: 19644

  More actions

  January 25, 2007 at 2:02 pm

  #685695

  http://community.bartdesmet.net/blogs/bart/archive/2005/07/26/3094.aspx

  http://www.sqlservercentral.com/scripts/viewscript.asp?scriptid=1577

   

  MohammedU
  Microsoft SQL Server MVP