DPA.Deadlock
SolarWinds Information Service 2020.2 Schema Documentation
Collected deadlock information
Inheritance
Access control
| Operations | Right |
|---|---|
| read | everyone |
Properties
| Name | Type | Summary | Access Control |
|---|---|---|---|
| DatabaseId | System.Int32 | ID of a monitored instance. References to Orion.DPA.DatabaseInstance.Id | everyone |
| GlobalDatabaseId | System.Int32 | Unique ID of database instance in Orion | everyone |
| DeadlockId | System.Int32 | ID of Deadlock | everyone |
| EventDate | System.DateTime | Time when the deadlock ocurred | everyone |
| VictimImpact | System.Int32 | Time impact on queries | everyone |
| SessionCount | System.Int32 | Number of sessions involved in the deadlock | everyone |
| Program | System.String | Name of the program that sent the query | everyone |
| Machine | System.String | ID of Deadlock | everyone |
| User | System.String | User under which the query was executed | everyone |
| Database | System.String | Name of the database affected by the deadlock | everyone |
| Object | System.String | Name of the deadlocked object (database table for example) | everyone |