Database | Table | Application | Created | Links |
master | monProcessStatement | 31 Aug 14 | Joins Schema ColumnUsage Queries Dependencies |
1 create table monProcessStatement(-- 0 Rows, Data: 2 KB, Index: 0 B 2 SPID int not null, 3 InstanceID tinyint not null, 4 KPID int not null, 5 DBID int not null, 6 ProcedureID int not null, 7 PlanID int not null, 8 BatchID int not null, 9 ContextID int not null, 10 LineNumber int not null, 11 CpuTime int not null, 12 WaitTime int not null, 13 MemUsageKB int not null, 14 PhysicalReads int not null, 15 LogicalReads int not null, 16 PagesModified int not null, 17 PacketsSent int not null, 18 PacketsReceived int not null, 19 NetworkPacketSize int not null, 20 PlansAltered int not null, 21 RowsAffected int not null, 22 DBName varchar(30) null, 23 StartTime datetime null 24 ) 25 26 Grant Select on monProcessStatement to mon_role 27
ALIASES USED for master..monProcessStatement |
NO_ALIAS |
1 |
SCHEMA |
COLUMN USAGE | |
SPID | sp_monitor_statement |
InstanceID | sp_monitor_statement |
KPID | sp_monitor_statement |
DBID | sp_monitor_statement |
ProcedureID | sp_monitor_statement |
PlanID | sp_monitor_statement |
BatchID | sp_monitor_statement |
ContextID | sp_monitor_statement |
LineNumber | sp_monitor_statement |
CpuTime | sp_monitor_statement |
WaitTime | sp_monitor_statement |
MemUsageKB | sp_monitor_statement |
PhysicalReads | sp_monitor_statement |
LogicalReads | sp_monitor_statement |
PagesModified | sp_monitor_statement |
PacketsSent | sp_monitor_statement |
PacketsReceived | sp_monitor_statement |
NetworkPacketSize | sp_monitor_statement |
PlansAltered | sp_monitor_statement |
RowsAffected | sp_monitor_statement |
DBName | sp_monitor_statement |
StartTime | sp_monitor_statement |
QUERIES | |
Joined With | Links |
DEPENDENCIES |
READERS AND WRITERS read by proc sybsystemprocs..sp_monitor_statement |