This is an example of a blocking chain that was captured by the blocking (current) panel for a SQL Server agent.
In this example the first column is collapsible where the + sign to indicate the chain of events.
A SPID in SQL Server is the Server Process ID. These process ID's are essentially sessions. Everytime an application connects to SQL Server, a new connection (or SPID) is created.
Wait time indicates how long this session has been waiting for the lock (measured in seconds). This shows 0 if the session is not waiting.
Type is the type of the currently locked resource (Database, table, page, row, extent, and more).(e.g. LCK_M_X which is an exclusive lock)
Resource is the name of the object that is involved in the lock.
Command is the type of command being run (e.g. INSERT, UPDATE, DELETE)
SQL User is the login name for the session
Program is the name of the program the user is running to access SQL Server
Win User name of the Windows login for the session
CPU is the amount of CPU time, in milliseconds, used by the event
I/O is the total number of I/O operations performed by the selected SQL statement
Host Name is the hostname that the session is running from
Status is the current status of the session (e.g. sleeping, running) and the process (e.g. running, blocking, blocked)
DBName is the name of the SQL Server instance database where the lock is taking place
Session SQL are details about the SQL statement or batch being executed against the database
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center