DBCC SQLPERF(SPINLOCKSTATS) 

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

DBCC SQLPERF(SPINLOCKSTATS)

The result set:

Spinlock Name                  Collisions  Spins                  Spins/Collision
------------------------------ ----------- ---------------------- ------------------------
MUTEX                          0           0                      0.0
CONNECTS                       0           0                      0.0
SRVPROC                        0           0                      0.0
QP_INIT                        0           0                      0.0
URT_GC                         0           0                      0.0
MISC                           0           0                      0.0
EXT_CACHE                      0           0                      0.0
FT_INIT                        0           0                      0.0
COM_INIT                       0           0                      0.0
DBT_HASH                       0           0                      0.0
LOCK_FREE_LIST                 0           0                      0.0
DES_HASH                       0           0                      0.0
BUF_HASH                       0           0                      0.0
PSS                            0           0                      0.0
CURSOR                         0           0                      0.0
RESOURCE                       0           0                      0.0
BUF                            0           0                      0.0
DBT_IO_LIST                    0           0                      0.0
LATCH                          0           0                      0.0
UPWAIT                         0           0                      0.0
RES_LOCK_HASH                  0           0                      0.0
RES_LOCK_FREELIST              0           0                      0.0
LOCK_HASH                      0           0                      0.0
DEADLOCK                       0           0                      0.0
MEM_MGR                        0           0                      0.0
BUF_FREE_LIST                  0           0                      0.0
DTC                            0           0                      0.0
XCB_FREE_LIST                  0           0                      0.0
XCB                            0           0                      0.0
XCB_HASH                       0           0                      0.0
DBTABLE                        0           0                      0.0
DBT_LAST_LOG                   0           0                      0.0
X_EC_GLOBAL                    0           0                      0.0
X_PORT                         0           0                      0.0
X_PIPE                         0           0                      0.0
X_PACKET_LIST                  0           0                      0.0
IDENTITY                       0           0                      0.0
BUF_LINK                       0           0                      0.0
DES                            0           0                      0.0
CACHE_MONITOR                  0           0                      0.0
MEMOBJ                         0           0                      0.0
READ_AHEAD                     0           0                      0.0
DROP                           0           0                      0.0
MEMOBJ_LIST                    0           0                      0.0
BACKUP_CKPT                    0           0                      0.0
BACKUP_CTX                     0           0                      0.0
XDESMGR                        0           0                      0.0
IOREQ                          0           0                      0.0
RESQUEUE                       0           0                      0.0
QUERYSCAN                      0           0                      0.0
LOGLFM                         0           0                      0.0
LOGLC                          0           0                      0.0
LOGFLUSHQ                      0           0                      0.0
XCHNG_TRACE                    0           0                      0.0
QUERYEXEC                      0           0                      0.0
PARALLEL_PAGESUPP              0           0                      0.0
BUF_WRITE_LOG                  0           0                      0.0
SQL_MGR                        0           0                      0.0
DROP_TEMPO                     0           0                      0.0
NHASH_BKT                      0           0                      0.0
IHASH_BKT                      0           0                      0.0
CACHEOBJ_DBG                   0           0                      0.0
GHOST_HASH                     0           0                      0.0
GHOST_FREE                     0           0                      0.0
ISSRESOURCE                    0           0                      0.0
RFS_KIM                        0           0                      0.0
RFS_MGR                        0           0                      0.0
RFS_VOLUME                     0           0                      0.0
RFS_THREAD                     0           0                      0.0
RFS_THREAD_QUEUE               0           0                      0.0
RFS_NODE                       0           0                      0.0
COMM_MGR                       0           0                      0.0
SORT_CACHE                     0           0                      0.0
DBCC_CHECK                     0           0                      0.0
SEEVENT                        0           0                      0.0
LSID                           0           0                      0.0
SQLEVENTFAC                    0           0                      0.0
XDES                           0           0                      0.0
MEMCACHE                       0           0                      0.0
SPECPROC_MAP_INIT              0           0                      0.0
INDEX_CREATE                   0           0                      0.0
QRYMEMMGRLIST                  0           0                      0.0
DINPBUF                        0           0                      0.0
CURSQL                         0           0                      0.0
WRITE_PAGE_RECORDER            0           0                      0.0
 

DBCC SQLPERF(SPINLOCKSTATS, 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.