Statement Cache Statistics and Details

The Statement Cache window displays information about SQL queries and query plans stored in the Adaptive Server statement cache.

The Statement Cache Summary gives details about the size, hit count, and traffic in the cache. The Cached Statements table lists SQL statements by statement ID (SSQLID), and gives the owner name, use count, CPU time, elapsed time to execute, and logical and physical I/O figures for each query.

The Cached Statement Text window displays the query selected in the Cached Statements table.

Note: A cached query and query plan can be reused only by the user who first entered the query. Thus, if two or more users enter the same query, it appears in the cache several times.
Related tasks
Monitoring Adaptive Server Data Caches
Monitoring the Adaptive Server Procedure Cache
Monitoring the Adaptive Server Statement Cache
Monitoring Adaptive Server In-memory Storage
Related reference
Data Cache Statistics and Details
Procedure Cache Statistics and Details
In-memory Storage Statistics and Details