The metrics in this category provide information pertaining to the most recent deadlocks that have occurred in Adaptive Server. You can tune the maximum number of messages returned with deadlock pipe max messages.
Collection frequency - Every 45 minutes
Table 3-24 Deadlock Statistics Metrics
Metric | Description and User Action |
---|---|
Application holding the lock |
Name of the application holding the lock. |
BatchID for the SQL executed by the process holding the lock In Release 9, this metric name has changed to: Lock Held Process executed SQL BatchID |
Unique batch identifier for the SQL code being executed by the process holding the lock when it was blocked by another process (not when it acquired the lock). |
Command being executed that caused the lock to be held |
The command being executed that caused the lock to be held. |
Context ID for the process holding the lock In Release 9, this metric name has changed to: Lock Held Process Context ID |
Unique context identifier for the process holding the lock when it was blocked by another process (not when it acquired the lock). |
Release 8 or lower SPID of the parent process of the process holding the lock |
SPID of the parent process of the process holding the lock. |
Release 8 or lower KPID of process holding the lock |
KPID of process holding the lock. |
Line number within the batch of the statement of the process In Release 9, this metric name has changed to: Lock Held Process executing Line Number within the batch |
Line number within the batch of the statement of the process. |
Type of lock being held In Release 9, this metric name has changed to: Holding lock type |
Type of lock being held. |
DBID where the stored procedure that caused the lock to be held resides In Release 9, this metric name has changed to: Lock held stored procedure's DBID |
DBID where the stored procedure that caused the lock to be held resides. |
Object ID of stored procedure holding the lock In Release 9, this metric name has changed to: Lock held stored procedure's Object ID |
Unique object identifier for the stored procedure that caused the lock to be held, if applicable. |
Release 8 or lower SPID of process holding the lock |
SPID of process holding the lock. |
Transaction in which the lock was acquired In Release 9, this metric name has changed to: Transaction holding the lock |
The name of the transaction in which the lock was acquired. |
User name for whom lock being held In Release 9, this metric name has changed to: User holding the lock |
Name of the user for whom the lock is being held. |
Object DBID |
Unique database identifier for database where the object resides. |
Object Name |
Name of the object. |
Page number for which the lock requested In Release 9, this metric name has changed to: Lock Requested Page Number |
Page number for which the lock requested, if applicable. |
Deadlock resolved time |
Time at which the deadlock was resolved. |
Row number for which the lock was requested In Release 9, this metric name has changed to: Lock Requested Row Number |
Row number for which the lock was requested, if applicable. |
Release 8 or lower SPID of the parent process of the process waiting for the lock |
SPID of the parent process of the process waiting for the lock. |
Release 8 or lower KPID of the process waiting for the lock |
KPID of the process waiting for the lock. |
Type of lock requested |
Type of lock requested. |
Release 8 or lower SPID of the process waiting for the lock |
SPID of the process waiting for the lock. |
Amount of time (ms) the waiting process was blocked In Release 9, this metric name has changed to: Blocked Process Waiting Time (ms) |
Amount of time in milliseconds that the waiting process was blocked before the deadlock was resolved. |
Name of the user for whom the lock is being requested In Release 9, this metric name has changed to: User requested/waiting for the lock |
Name of the user for whom the lock is being requested. |
Deadlock ID |
Unique identifier for the deadlock. |
Held Process FID/SPID/KPID |
FID / SPID / KPID of the process holding the lock. |
Victim KPID |
KPID of the victim process for the deadlock. |
Wait Process FID/SPID/KPID |
FID / SPID / KPID of the process waiting for the lock. |