Export (0) Print
Expand All

SQL Server: Cache Manager Object

SQL Server 2000

SQL Server: Cache Manager Object

The Cache Manager object provides counters to monitor how Microsoft® SQL Server™ uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers. Multiple instances of the Cache Manager object can be monitored at the same time, with each instance representing a different type of plan to monitor.

Cache Manager instance Description
Ad hoc SQL Plans Query plans produced from an ad hoc Transact-SQL query, including auto-parameterized queries. SQL Server caches the plans for ad hoc SQL statements for later reuse if the identical Transact-SQL statement is later executed.
Misc. Normalized Trees Normalized trees for views, rules, computed columns, and check constraints.
Prepared SQL Plans Query plans that correspond to Transact-SQL statements prepared using sp_prepare, sp_cursorprepare, or auto-parameterization. User-parameterized queries (even if not explicitly prepared) are also monitored as Prepared SQL Plans.
Procedure Plans Query plans generated by creating a stored procedure.
Replication Procedure Plans Query plans of a replication system stored procedure.
Trigger Plans Query plans generated by creating a trigger.

These are the SQL Server Cache Manager counters.

SQL Server Cache Manager counters Description
Cache Hit Ratio Ratio between cache hits and lookups.
Cache Object Counts Number of cache objects in the cache.
Cache Pages Number of 8-kilobyte (KB) pages used by cache objects.
Cache Use Counts/sec Times each type of cache object has been used.

For more information about caching query plans, see Execution Plan Caching and Reuse.

See Also

Server Memory Options

SQL Server: Buffer Manager Object

Show:
© 2014 Microsoft