SQL Statement Cache: Statements Cached 0.6 2.7 171 n/a Statements Found in Cache 2.0 9.5 611 n/a Statements Not Found 0.6 2.7 171 n/a Statements Dropped 0.2 0.8 52 n/a Statements Restored 0.0 0.0 0 n/a Statements Not Cached 0.0 0.0 0 n/a
Statements Cached – number of statements added to the statement cache during the sample period.
Statements Found in Cache – number of statements found in the statement cache. This value represents the number of times Adaptive Server used the statement cache to avoid recompiling a statement.
Statements Not Found – number of times Adaptive Server looked for, but did not find, a statement in the statement cache.
Statements Dropped – number of times Adaptive Server removed a statement already in the statement cache to make room for a new statement being cached.
Statements Restored – number of query plans restored after an existing plan was invalidated by a schema change to an object referenced by the statement.
Statements Not Cached – number of statements Adaptive Server compiled, but did not enter, into the statement cache. If you have set statement cache size to 0 (disabling the statement cache), Statements Not Cached is the number of statements that Adaptive Server could have cached.