Cached statement statistics
(INSTANCEID, SSQLID, HASHKEY)
| Name | Data Type | Description |
|---|---|---|
| INSTANCEID | long | Instance ID; 0 = non-CE |
| SSQLID | long | Cached statement ID |
| HASHKEY | long | Hash value of the statement text |
| USERID | long | User ID of the user which executed the statement which was cached |
| USERNAME | string(32) | Name of the user which executed the statement which was cached |
| SUSERID | long | Server user ID of the user which executed the statement which was cached |
| LOGIN | string(32) | Login name |
| DBID | long | Database ID |
| USECOUNT | long | Total number of times the statement was used after being cached |
| STATEMENTSIZE | long | Cached statement size, in bytes |
| MINPLANSIZEKB | long | Size of the plan when it is not in use, in kilobytes |
| MAXPLANSIZEKB | long | Size of the plan when it is in use, in kilobytes |
| CURRENTUSAGECOUNT | long | Number of active queries for the statement |
| MAXUSAGECOUNT | long | Maximum number of simultaneous queries for the statement |
| NUMRECOMPILESSCHEMACHANGES | long | Number of recompiles due to schema changes (including update statistics on a table) |
| NUMRECOMPILESPLANFLUSHES | long | Number of recompiles due to the plan not being found in the cache (i.e. it was flushed out) |
| HASAUTOPARAMS | string(8) | Whether the statement has any parameterized literals (Yes, No) |
| PARALLELDEGREE | long | Degree of parallelism |
| QUOTEDIDENTIFIER | long | Whether set quoted_identifier was set; 1 = yes, 0 = no |
| TRANSACTIONISOLATIONLEVEL | long | Transaction isolation level |
| TRANSACTIONMODE | long | Whether "chained transaction mode" was set; 1 = yes, 0 = no |
| SAAUTHORIZATION | long | Whether the user had sa_role authorization; 1 = yes, 0 = no |
| SYSTEMCATALOGUPDATE | long | Whether "allow catalog updates" was set; 1 = yes, 0 = no |
| METRICSCOUNT | long | Number of times metrics were aggregated |
| MINPIO | long | Minimum physical I/Os per statement execution |
| MAXPIO | long | Maximum physical I/Os per statement execution |
| AVGPIO | long | Average physical I/Os per statement execution |
| MINLIO | long | Minimum logical I/Os per statement execution |
| MAXLIO | long | Maximum logical I/Os per statement execution |
| AVGLIO | long | Average logical I/Os per statement execution |
| MINCPUTIME | long | Minimum CPU time per statement execution |
| MAXCPUTIME | long | Maximum CPU time per statement execution |
| AVGCPUTIME | long | Average CPU time per statement execution |
| MINELAPSEDTIME | long | Minimum elapsed time per statement execution |
| MAXELAPSEDTIME | long | Maximum elapsed time per statement execution |
| AVGELAPSEDTIME | long | Average elapsed time per statement execution |
| DBNAME | string(32) | Database name |
| CACHEDDATE | time | Time when the statement was cached |
| LASTUSEDDATE | time | Time when the statement was last used |
| LASTRECOMPILEDDATE | time | Time when the statement was last recompiled |
| SQLTEXT | string(256) | SQL text preview |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| MINPLANSIZEB | double | Size of the plan when it is not in use, in bytes |
| MAXPLANSIZEB | double | Size of the plan when it is in use, in bytes |
| Attributes: | MDA |
|---|---|
| Minimum database version: | 15.0.2 |