Summary statistics about the statement cache
(INSTANCEID)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| CACHENAME | string(16) | Literal: "Statement Cache"; created by Surveillance |
| TOTALSIZEKB | double | Configured size of the statement cache, in kilobytes |
| USEDSIZEKB | double | Amount of the statement cache that is currently in use, in kilobytes |
| NUMSTATEMENTS | long | Number of statements |
| NUMSEARCHES | long | Number of searches performed |
| HITCOUNT | long | Number of searches performed where a match was found |
| MISSCOUNT | long | Number of searches performed where a match was not found |
| NUMINSERTS | long | Number of inserted statements |
| NUMREMOVALS | long | Number of removed statements |
| NUMRECOMPILESSCHEMACHANGES | long | Number of recompiles due to schema changes |
| NUMRECOMPILESPLANFLUSHES | long | Number of recompiles due to plan flushes |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| TOTALSIZEB | double | Configured size of the statement cache, in bytes |
| USEDSIZEB | double | Amount of the statement cache that is currently in use, in bytes |
| NUMSEARCHES_CURRENT | double | Delta number of searches performed |
| NUMSEARCHES_OVERALL | double | Total number of searches performed, since collection started |
| HITCOUNT_CURRENT | double | Delta number of searches performed where a match was found |
| HITCOUNT_OVERALL | double | Total number of searches performed where a match was found, since collection started |
| NUMINSERTS_CURRENT | double | Delta number of inserted statements |
| NUMINSERTS_OVERALL | double | Total number of inserted statements, since collection started |
| NUMREMOVALS_CURRENT | double | Delta number of removed statements |
| NUMREMOVALS_OVERALL | double | Total number of removed statements, since collection started |
| MISSCOUNT_CURRENT | double | Delta number of searches performed where a match was not found |
| MISSCOUNT_OVERALL | double | Total number of searches performed where a match was not found, since collection started |
| MISS_PCT | double | Search miss %, in interval |
| MISS_PCT_AVG | double | Average search miss %, over each interval since collection started |
| MISS_PCT_MAX | double | Maximum search miss %, over each interval since collection started |
| TOT_MISS_PCT | double | Search miss %, since ASE instance started |
| OVR_MISS_PCT | double | Search miss %, over all intervals since collection started |
| USED_PCT | double | % of statement cache currently in use |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.0.2 |