Data cache activity, and summary statistics for the statement cache
Columns
| Name |
Description |
| Cache Name |
Data cache name |
| Logical IO / Sec |
Number of logical reads per second, in interval |
| Physical IO / Sec |
Number of physical I/Os per second, in interval, broken down by reads and writes |
| Physical Throughput / Sec |
Bytes read per second, in interval |
| Miss % |
Data cache miss %, or how often logical reads required physical reads |
| Cur Stalls |
Delta number of stalls |
| Ovr Stalls |
Total number of stalls, since collection started |
| Buffer Pools |
Number of buffer pools defined in the data cache |
| Instances |
Number of instances using the data cache, if Cluster Edition |
| Cur Searches |
Delta number of cache searches |
| Ovr Searches |
Total number of cache searches, since collection started |
| Cache Used % |
% of total allocated space that is used |
| Cache Used |
Amount of space used |
| Cache Total |
Total allocated size |
| Cache Partitions |
Number of partitions in the data cache |
| Relaxed Replace |
Whether cache is using relaxed replacement strategy; 1 = yes, 0 = no |
| Cur Logical Reads |
Delta number of logical reads |
| Ovr Logical Reads |
Total number of logical reads, since collection started |
| Total Logical Reads |
Number of logical reads |
| Cur Physical Reads |
Delta number of physical reads |
| Ovr Physical Reads |
Total number of physical reads, since collection started |
| Total Physical Reads |
Number of physical reads |
| Cur Physical Writes |
Delta number of physical writes |
| Ovr Physical Writes |
Total number of physical writes, since collection started |
| Total Physical Writes |
Number of physical writes |
Procedure Cache Activity Tab - Columns
| Name |
Description |
| Cache Name |
Literal: "Procedure Cache"; created by Surveillance |
| Cur Requests |
Delta number of requests |
| Total Requests |
Number of requests |
| Cur Loads |
Delta number of loads |
| Total Loads |
Number of loads |
| Cur Writes |
Delta number of writes |
| Total Writes |
Number of writes |
| Cur Stalls |
Delta number of stalls |
| Total Stalls |
Number of stalls |
Statement Cache Activity - Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| Cache Name |
Literal: "Statement Cache"; created by Surveillance |
| Used |
Amount of the statement cache that is currently in use |
| Total Size |
Configured size of the statement cache |
| Stmt Count |
Number of statements |
| Cache Miss % |
Search miss %, in interval |
| Cur Hits |
Delta number of searches performed where a match was found |
| Ovr Hits |
Total number of searches performed where a match was found, since collection started |
| Cur Searches |
Delta number of searches performed |
| Ovr Searches |
Total number of searches performed, since collection started |
| Total Miss % |
Search miss %, since ASE instance started |
| Ovr Miss % |
Search miss %, over all intervals since collection started |
| Cur Inserted |
Delta number of inserted statements |
| Ovr Inserted |
Total number of inserted statements, since collection started |
| Cur Removed |
Delta number of removed statements |
| Ovr Removed |
Total number of removed statements, since collection started |
| Recompiles (Schema) |
Number of recompiles due to schema changes |
| Recompiles (Plan Flush) |
Number of recompiles due to plan flushes |
Entity Requirements
| Attributes: |
MDA |
| Minimum database version: |
15.0.2 |