Database	Table	Application	Created	Links
master	monOpenObjectActivity		31 Aug 14	Joins Schema ColumnUsage Queries Dependencies

1     create table monOpenObjectActivity(-- 0 Rows, Data: 2 KB, Index: 0 B
2         DBID int not null,
3         ObjectID int not null,
4         IndexID int not null,
5         InstanceID tinyint not null,
6         DBName varchar(30) null,
7         ObjectName varchar(30) null,
8         LogicalReads int null,
9         PhysicalReads int null,
10        APFReads int null,
11        PagesRead int null,
12        PhysicalWrites int null,
13        PagesWritten int null,
14        RowsInserted int null,
15        RowsDeleted int null,
16        RowsUpdated int null,
17        Operations int null,
18        LockRequests int null,
19        LockWaits int null,
20        OptSelectCount int null,
21        LastOptSelectDate datetime null,
22        UsedCount int null,
23        LastUsedDate datetime null,
24        HkgcRequests int null,
25        HkgcPending int null,
26        HkgcOverflows int null,
27        PhysicalLocks int null,
28        PhysicalLocksRetained int null,
29        PhysicalLocksRetainWaited int null,
30        PhysicalLocksDeadlocks int null,
31        PhysicalLocksWaited int null,
32        PhysicalLocksPageTransfer int null,
33        TransferReqWaited int null,
34        AvgPhysicalLockWaitTime real null,
35        MaxPhysicalLockWaitTime real null,
36        AvgTransferReqWaitTime real null,
37        MaxTransferReqWaitTime real null,
38        TotalServiceRequests int null,
39        PhysicalLocksDowngraded int null,
40        PagesTransferred int null,
41        ClusterPageWrites int null,
42        AvgServiceTime real null,
43        MaxServiceTime real null,
44        AvgQueueWaitTime real null,
45        MaxQueueWaitTime real null,
46        AvgTimeWaitedOnLocalUsers real null,
47        MaxTimeWaitedOnLocalUsers real null,
48        AvgTransferSendWaitTime real null,
49        MaxTransferSendWaitTime real null,
50        AvgIOServiceTime real null,
51        MaxIOServiceTime real null,
52        AvgDowngradeServiceTime real null,
53        MaxDowngradeServiceTime real null,
54        SharedLockWaitTime int null,
55        ExclusiveLockWaitTime int null,
56        UpdateLockWaitTime int null,
57        ObjectCacheDate datetime null
58    )
59    
60    Grant Select on monOpenObjectActivity to mon_role
61    

SCHEMA

DEPENDENCIES

READERS AND WRITERS read by proc sybsystemprocs..sp_sysmon_collect_mda      called by proc sybsystemprocs..sp_sysmon_collect         called by proc sybsystemprocs..sp_sysmon