| Database | Table | Application | Created | Links |
| master | monThread | ![]() | 31 Aug 14 | Joins 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 | ||||||||||||
|
| ALIASES USED for master..monThread | |||
| NO_ALIAS | mt | t | th |
| 1 | 1 | 1 | 1 |
| SCHEMA |
![]() |
| COLUMN USAGE | |
| InstanceID | sp_helpthread |
| ThreadID | sp_helpthread sp_sysmon sp_sysmon_collect sp_sysmon_kernel_threaded |
| KTID | sp_sysmon_collect |
| OSThreadID | sp_helpthread |
| ThreadPoolID | sp_sysmon_collect sp_sysmon_kernel_threaded |
| UserTime | sp_sysmon_collect |
| SystemTime | sp_sysmon_collect |
| MinorFaults | sp_sysmon_collect |
| MajorFaults | sp_sysmon_collect |
| VoluntaryCtxtSwitches | sp_sysmon_collect |
| NonVoluntaryCtxtSwitches | sp_sysmon_collect |
| State | sp_helpthread |
| ThreadPoolName | sp_helpthread sp_sysmon |
| ThreadAffinity | sp_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 |