The monStatementCache table

Table 12-1 provides information about the name, the SQL datatype, attributes and description for each column in monStatementCache. The columns in monStatementCache allow two attributes, counter if the column has a counter value, and reset if the column can be reset using mechanisms like sp_sysmon.

**Table 12-1: monStatementCache**
Name	Type	Attributes	Description
TotalSizeKB	int		The configured size of the statement cache in KB.
UsedSizeKB	int		The amount of the statement cache currently in use.
NumStatements	int		The number of statements in the statement cache.
NumSearches	int	Counter/Reset	The number of times the statement cache was looked up.
HitCount	int	Counter/Reset	The number of times the statement cache was looked up and a match was found.
NumInserts	int	Counter/Reset	The number of statements that were inserted into the statement cache.
NumRemovals	int	Counter/Reset	The number of times statements were removed from the statement cache. This value includes both statements that were removed via explicit purges or due to a replacement strategy.
NumRecompilesSchemaChanges	int	Counter/Reset	The number of recompiles due to schema changes in the tables referred to in the cached statements.
NumRecompilesPlanFlushes	int	Counter/Reset	Number of recompiles due to the plan flushes from the cache.