DatabaseTableApplicationCreatedLinks
mastermonProcessStatement  31 Aug 14Joins 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
SPIDsp_monitor_statement 
InstanceIDsp_monitor_statement 
KPIDsp_monitor_statement 
DBIDsp_monitor_statement 
ProcedureIDsp_monitor_statement 
PlanIDsp_monitor_statement 
BatchIDsp_monitor_statement 
ContextIDsp_monitor_statement 
LineNumbersp_monitor_statement 
CpuTimesp_monitor_statement 
WaitTimesp_monitor_statement 
MemUsageKBsp_monitor_statement 
PhysicalReadssp_monitor_statement 
LogicalReadssp_monitor_statement 
PagesModifiedsp_monitor_statement 
PacketsSentsp_monitor_statement 
PacketsReceivedsp_monitor_statement 
NetworkPacketSizesp_monitor_statement 
PlansAlteredsp_monitor_statement 
RowsAffectedsp_monitor_statement 
DBNamesp_monitor_statement 
StartTimesp_monitor_statement 

QUERIES
Joined With Links

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_monitor_statement