DatabaseTableApplicationCreatedLinks
mastermonEngine  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monEngine(-- 0 Rows, Data: 2 KB, Index: 0 B
2         EngineNumber smallint not null,
3         ThreadID int not null,
4         InstanceID tinyint not null,
5         CurrentKPID int not null,
6         PreviousKPID int not null,
7         CPUTime int not null,
8         SystemCPUTime int not null,
9         UserCPUTime int not null,
10        IOCPUTime int not null,
11        IdleCPUTime int not null,
12        Yields int not null,
13        Connections int not null,
14        DiskIOChecks int not null,
15        DiskIOPolled int not null,
16        DiskIOCompleted int not null,
17        MaxOutstandingIOs int not null,
18        ProcessesAffinitied int not null,
19        ContextSwitches int not null,
20        HkgcMaxQSize int not null,
21        HkgcPendingItems int not null,
22        HkgcHWMItems int not null,
23        HkgcOverflows int not null,
24        Status varchar(20) null,
25        StartTime datetime null,
26        StopTime datetime null,
27        AffinitiedToCPU int null,
28        OSPID int null
29    )
30    
31    Grant Select on monEngine to public
32    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[ThreadID]master..monThread[ThreadID]4 Simple Join
[EngineNumber]master..monSysLoad[EngineNumber]2 Simple Join

ALIASES USED for master..monEngine
eme
11

SCHEMA

COLUMN USAGE
EngineNumbersp_sysmon  sp_sysmon_kernel_threaded 
ThreadIDsp_sysmon  sp_sysmon_kernel_threaded 

QUERIES
Joined With Links
master..monThread sybsystemprocs..sp_sysmon:714
master..monSysLoad master..monThread sybsystemprocs..sp_sysmon_kernel_threaded:94

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_sysmon_kernel_threaded  
   called by proc sybsystemprocs..sp_sysmon_analyze  
      called by proc sybsystemprocs..sp_sysmon  
read by proc sybsystemprocs..sp_sysmon_collect  
   called by proc sybsystemprocs..sp_sysmon