DBCC SQLPERF(UMSSPINSTATS) 

Home
Up
What's New
DTS
SQL-DMO
SQL-NS
XP's
SQL Agent
Misc. Tools
Events
Articles
FAQ
Links
About...

DBCC SQLPERF(UMSSPINSTATS)

The result set:

Spinlock Name                  Collisions  Spins       Spins/Collision
------------------------------ ----------- ----------- ------------------------
                 SCHEDULERLIST 0           0           0.0
                   RUNNABLEQUE 0           0           0.0
                      EVENTQUE 0           0           0.0
                       WORKQUE 0           0           0.0
                     WORKERQUE 0           0           0.0
 

DBCC SQLPERF(UMSSPINSTATS, CLEAR) resets the counter, this is a service/instance wide reset, not per session!

Questions or problems regarding this web site should be directed to Web Master.
Copyright © 1991-2005 SQLDev.Net. All rights reserved.
Last modified: 04/06/05.