1 create table monProcessActivity(-- 0 Rows, Data: 2 KB, Index: 0 B
2 SPID int not null,
3 InstanceID tinyint not null,
4 KPID int not null,
5 ServerUserID int not null,
6 CPUTime int not null,
7 WaitTime int not null,
8 PhysicalReads int not null,
9 LogicalReads int not null,
10 PagesRead int not null,
11 PhysicalWrites int not null,
12 PagesWritten int not null,
13 MemUsageKB int not null,
14 LocksHeld int not null,
15 TableAccesses int not null,
16 IndexAccesses int not null,
17 TempDbObjects int not null,
18 WorkTables int not null,
19 ULCBytesWritten int not null,
20 ULCFlushes int not null,
21 ULCFlushFull int not null,
22 ULCMaxUsage int not null,
23 ULCCurrentUsage int not null,
24 Transactions int not null,
25 Commits int not null,
26 Rollbacks int not null,
27 HeapMemoryInUseKB int not null,
28 HeapMemoryUsedHWM_KB int not null,
29 HeapMemoryReservedKB int not null,
30 HeapMemoryAllocs int not null,
31 Application varchar(30) null,
32 HostName varchar(30) null,
33 ClientName varchar(30) null,
34 ClientHostName varchar(30) null,
35 ClientApplName varchar(30) null
36 )
37
38 Grant Select on monProcessActivity to mon_role
39
ALIASES USED for master..monProcessActivity |
NO_ALIAS |
1 |
SCHEMA |
|
QUERIES |
Joined With | Links |