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 |
|
QUERIES |
Joined With | Links |