DatabaseTableApplicationCreatedLinks
mastermonCachePool  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monCachePool(-- 0 Rows, Data: 2 KB, Index: 0 B
2         CacheID int not null,
3         InstanceID tinyint not null,
4         IOBufferSize int not null,
5         AllocatedKB int not null,
6         PhysicalReads int not null,
7         APFReads int not null,
8         LogicalReads int not null,
9         PhysicalWrites int not null,
10        Stalls int not null,
11        PagesTouched int not null,
12        PagesRead int not null,
13        BuffersToMRU int not null,
14        BuffersToLRU int not null,
15        APFPercentage int not null,
16        WashSize int not null,
17        CacheName varchar(30) null
18    )
19    
20    Grant Select on monCachePool to mon_role
21    
ALIASES USED for master..monCachePool
NO_ALIAS
2

SCHEMA

COLUMN USAGE
CacheIDsp_sysmon_collect_mda 
IOBufferSizesp_sysmon_collect_mda 
AllocatedKBsp_sysmon_collect_mda 
PhysicalReadssp_sysmon_collect_mda 
PagesTouchedsp_sysmon_collect_mda 
CacheNamesp_sysmon_collect_mda 

QUERIES
Joined With Links

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