Page tree
Skip to end of metadata
Go to start of metadata

pss

Print the contents of a Process Status Structure Spinlock param added in 12.0.0.6 ESD#1 and 12.5.0.3 under CR 256320.

Syntax:

dbcc pss[([suid [, spid [, printopt [,getspinlock] ] ] ] ) ]

Option

Description

suid

Server user ID. If 0 (default), then all are displayed

spid

Server process ID. If 0 (default), then all spids matching the suid are displayed.

printopts

Output options for dbcc pss
0 PSS structures
1 PSS structures, open DES's and sequence trees
2 Print all held locks for the process/user ID
3 Display the first 50 Cursors for the spid
4 Prints information about each transaction the spid has started
5 Prints information about work table descriptors for this spid

getspinlock

Specify 1 to use spinlock and avoid some SIGV errors. Default is 0 (no spinlocks). Can only be used with printopt 2.

  • No labels