DatabaseTableApplicationCreatedLinks
mastermonProcessWaits  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monProcessWaits(-- 0 Rows, Data: 2 KB, Index: 0 B
2         SPID int not null,
3         InstanceID tinyint not null,
4         KPID int not null,
5         ServerUserID int not null,
6         WaitEventID smallint not null,
7         Waits int not null,
8         WaitTime int not null
9     )
10    
11    Grant Select on monProcessWaits to mon_role
12    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[WaitEventID]master..monWaitEventInfo[WaitEventID]6 Simple Join
[SPID]master..monProcessLookup[SPID]2 Simple Join

ALIASES USED for master..monProcessWaits
mpw
3

SCHEMA

COLUMN USAGE
SPIDsp_monitor_event 
WaitEventIDsp_monitor_event 
WaitTimesp_monitor_event 

QUERIES
Joined With Links
master..monWaitEventInfo sybsystemprocs..sp_monitor_event:61
sybsystemprocs..sp_monitor_event:88
master..monProcessLookup master..monWaitEventInfo sybsystemprocs..sp_monitor_event:73

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_event