The sa_diagnostic_deadlock table is owned by the dbo user. When diagnostic tracing is enabled and is set to include tracing of deadlock events, a set of rows is inserted into this table every time a deadlock occurs (one row for each connection that was part of the deadlock is inserted). The set of all rows that comprise a single deadlock event is uniquely identified by a snapshot_id.
Columns| Column name | Column type | Description |
|---|---|---|
| logging_session_id | UNSIGNED INT |
A number uniquely identifying the logging session during which the diagnostic information was gathered. |
| snapshot_id | UNSIGNED BIGINT |
A number identifying which deadlock event this row is a part of. Note that this column has nothing to do with snapshot isolation. |
| snapshot_at | TIMESTAMP |
The time at which the deadlock occurred. |
| waiter | UNSIGNED INT |
The connection number of the connection that this row represents. |
| request_id | UNSIGNED BIGINT |
The ID of the request that this connection was processing when the deadlock occurred. |
| original_table_object_id | UNSIGNED BIGINT |
The object ID of the table on which this connection was blocked. |
| rowid | UNSIGNED BIGINT |
The record ID of the row on which this connection was blocked. |
| owner | UNSIGNED INT |
The connection number of the connection that locked the desired row. |
| rollback_operation_count | UNSIGNED INT |
The number of uncommitted operations. |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |