DatabaseTableApplicationCreatedLinks
mastermonSysStatement  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monSysStatement(-- 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        ErrorStatus int not null,
23        HashKey int not null,
24        SsqlId int not null,
25        ProcNestLevel int not null,
26        StatementNumber int not null,
27        DBName varchar(30) null,
28        StartTime datetime null,
29        EndTime datetime null
30    )
31    
32    Grant Select on monSysStatement to mon_role
33    
ALIASES USED for master..monSysStatement
NO_ALIAS
3

SCHEMA

COLUMN USAGE
SPIDsp_monitor_procedure 
DBIDsp_monitor_procedure 
ProcedureIDsp_monitor_procedure 
BatchIDsp_monitor_procedure 
CpuTimesp_monitor_procedure 
WaitTimesp_monitor_procedure 
PhysicalReadssp_monitor_procedure 
LogicalReadssp_monitor_procedure 
PacketsSentsp_monitor_procedure 
StartTimesp_monitor_procedure 
EndTimesp_monitor_procedure 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_procedure