 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! | 
