DatabaseTableApplicationCreatedLinks
mastermonDeadLock  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monDeadLock(-- 0 Rows, Data: 2 KB, Index: 0 B
2         DeadlockID int not null,
3         VictimKPID int not null,
4         InstanceID tinyint not null,
5         ResolveTime datetime not null,
6         ObjectDBID int not null,
7         ObjectID int not null,
8         PageNumber int not null,
9         RowNumber int not null,
10        HeldFamilyID int not null,
11        HeldSPID int not null,
12        HeldKPID int not null,
13        HeldInstanceID int not null,
14        HeldProcDBID int not null,
15        HeldProcedureID int not null,
16        HeldBatchID int not null,
17        HeldContextID int not null,
18        HeldLineNumber int not null,
19        HeldStmtNumber int not null,
20        HeldNumLocks int not null,
21        WaitFamilyID int not null,
22        WaitSPID int not null,
23        WaitKPID int not null,
24        WaitProcDBID int not null,
25        WaitProcedureID int not null,
26        WaitBatchID int not null,
27        WaitContextID int not null,
28        WaitLineNumber int not null,
29        WaitStmtNumber int not null,
30        WaitTime int not null,
31        ObjectDBName varchar(255) null,
32        ObjectName varchar(30) null,
33        HeldUserName varchar(30) null,
34        HeldApplName varchar(30) null,
35        HeldHostName varchar(30) null,
36        HeldClientName varchar(30) null,
37        HeldClientHostName varchar(30) null,
38        HeldClientApplName varchar(30) null,
39        HeldTranName varchar(255) null,
40        HeldLockType varchar(20) null,
41        HeldCommand varchar(30) null,
42        HeldProcDBName varchar(30) null,
43        HeldProcedureName varchar(30) null,
44        WaitUserName varchar(30) null,
45        WaitApplName varchar(30) null,
46        WaitHostName varchar(30) null,
47        WaitClientName varchar(30) null,
48        WaitClientHostName varchar(30) null,
49        WaitClientApplName varchar(30) null,
50        WaitLockType varchar(20) null,
51        WaitTranName varchar(255) null,
52        WaitCommand varchar(30) null,
53        WaitProcDBName varchar(30) null,
54        WaitProcedureName varchar(30) null,
55        HeldSourceCodeID varchar(30) null,
56        WaitSourceCodeID varchar(30) null
57    )
58    
59    Grant Select on monDeadLock to mon_role
60    
ALIASES USED for master..monDeadLock
NO_ALIAS
1

SCHEMA

COLUMN USAGE
DeadlockIDsp_monitor_deadlock 
VictimKPIDsp_monitor_deadlock 
InstanceIDsp_monitor_deadlock 
ResolveTimesp_monitor_deadlock 
ObjectDBIDsp_monitor_deadlock 
ObjectIDsp_monitor_deadlock 
PageNumbersp_monitor_deadlock 
RowNumbersp_monitor_deadlock 
HeldFamilyIDsp_monitor_deadlock 
HeldSPIDsp_monitor_deadlock 
HeldKPIDsp_monitor_deadlock 
HeldInstanceIDsp_monitor_deadlock 
HeldProcDBIDsp_monitor_deadlock 
HeldProcedureIDsp_monitor_deadlock 
HeldBatchIDsp_monitor_deadlock 
HeldContextIDsp_monitor_deadlock 
HeldLineNumbersp_monitor_deadlock 
HeldStmtNumbersp_monitor_deadlock 
HeldNumLockssp_monitor_deadlock 
WaitFamilyIDsp_monitor_deadlock 
WaitSPIDsp_monitor_deadlock 
WaitKPIDsp_monitor_deadlock 
WaitProcDBIDsp_monitor_deadlock 
WaitProcedureIDsp_monitor_deadlock 
WaitBatchIDsp_monitor_deadlock 
WaitContextIDsp_monitor_deadlock 
WaitLineNumbersp_monitor_deadlock 
WaitStmtNumbersp_monitor_deadlock 
WaitTimesp_monitor_deadlock 
ObjectDBNamesp_monitor_deadlock 
ObjectNamesp_monitor_deadlock 
HeldUserNamesp_monitor_deadlock 
HeldApplNamesp_monitor_deadlock 
HeldHostNamesp_monitor_deadlock 
HeldClientNamesp_monitor_deadlock 
HeldClientHostNamesp_monitor_deadlock 
HeldClientApplNamesp_monitor_deadlock 
HeldTranNamesp_monitor_deadlock 
HeldLockTypesp_monitor_deadlock 
HeldCommandsp_monitor_deadlock 
HeldProcDBNamesp_monitor_deadlock 
HeldProcedureNamesp_monitor_deadlock 
WaitUserNamesp_monitor_deadlock 
WaitApplNamesp_monitor_deadlock 
WaitHostNamesp_monitor_deadlock 
WaitClientNamesp_monitor_deadlock 
WaitClientHostNamesp_monitor_deadlock 
WaitClientApplNamesp_monitor_deadlock 
WaitLockTypesp_monitor_deadlock 
WaitTranNamesp_monitor_deadlock 
WaitCommandsp_monitor_deadlock 
WaitProcDBNamesp_monitor_deadlock 
WaitProcedureNamesp_monitor_deadlock 
HeldSourceCodeIDsp_monitor_deadlock 
WaitSourceCodeIDsp_monitor_deadlock 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_deadlock  
   called by proc sybsystemprocs..sp_monitor