DatabaseTableApplicationCreatedLinks
mastermonThread  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monThread(-- 0 Rows, Data: 2 KB, Index: 0 B
2         InstanceID tinyint not null,
3         ThreadID int not null,
4         KTID int not null,
5         OSThreadID int not null,
6         AltOSThreadID int not null,
7         ThreadPoolID int not null,
8         TaskRuns bigint not null,
9         TotalTicks bigint not null,
10        IdleTicks bigint not null,
11        SleepTicks bigint not null,
12        BusyTicks bigint not null,
13        UserTime bigint not null,
14        SystemTime bigint not null,
15        MinorFaults bigint not null,
16        MajorFaults bigint not null,
17        VoluntaryCtxtSwitches bigint not null,
18        NonVoluntaryCtxtSwitches bigint not null,
19        State varchar(30) null,
20        ThreadPoolName varchar(30) null,
21        ThreadAffinity int null
22    )
23    
24    Grant Select on monThread to public
25    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[ThreadID]master..monEngine[ThreadID]4 Simple Join

ALIASES USED for master..monThread
NO_ALIASmttth
1111

SCHEMA

COLUMN USAGE
InstanceIDsp_helpthread 
ThreadIDsp_helpthread  sp_sysmon  sp_sysmon_collect  sp_sysmon_kernel_threaded 
KTIDsp_sysmon_collect 
OSThreadIDsp_helpthread 
ThreadPoolIDsp_sysmon_collect  sp_sysmon_kernel_threaded 
UserTimesp_sysmon_collect 
SystemTimesp_sysmon_collect 
MinorFaultssp_sysmon_collect 
MajorFaultssp_sysmon_collect 
VoluntaryCtxtSwitchessp_sysmon_collect 
NonVoluntaryCtxtSwitchessp_sysmon_collect 
Statesp_helpthread 
ThreadPoolNamesp_helpthread  sp_sysmon 
ThreadAffinitysp_helpthread 

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

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_helpthread  
read by proc sybsystemprocs..sp_sysmon_collect  
   called by proc sybsystemprocs..sp_sysmon  
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