MIB Viewer

ss2PlanCacheTable

OBJECT-TYPE
1.3.6.1.4.1.9600.1.13.2.23
Access
not-accessible
Status
current
Sub-identifiers
1
The Plan Cache object provides counters to monitor how SQL Server uses memory to store objects such as stored procedures, ad hoc and prepared Transact-SQL statements, and triggers. Multiple instances of the Plan Cache object can be monitored at the same time, with each instance representing a different type of plan to monitor.
SEQUENCE OF SQLServerPlanCacheEntry