DatabaseTableApplicationCreatedLinks
mastermonDataCache  31 Aug 14Joins Schema ColumnUsage Queries Dependencies

1     create table monDataCache(-- 0 Rows, Data: 2 KB, Index: 0 B
2         CacheID int not null,
3         InstanceID tinyint not null,
4         RelaxedReplacement int not null,
5         BufferPools int not null,
6         CacheSearches int not null,
7         PhysicalReads int not null,
8         APFReads int not null,
9         LogicalReads int not null,
10        PhysicalWrites int not null,
11        Stalls int not null,
12        CachePartitions smallint not null,
13        CacheSize int not null,
14        Overhead int not null,
15        CacheName varchar(30) null,
16        Status varchar(30) null,
17        Type varchar(30) null,
18        ReplacementStrategy varchar(30) null
19    )
20    
21    Grant Select on monDataCache to mon_role
22    
ALIASES USED for master..monDataCache
NO_ALIAS
2

SCHEMA

COLUMN USAGE
CacheIDsp_sysmon_collect_mda 
RelaxedReplacementsp_sysmon_collect_mda 
PhysicalReadssp_sysmon_collect_mda 
LogicalReadssp_sysmon_collect_mda 
CachePartitionssp_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