All MIBs › INFORMANT-SQLSERVER-V2 › ss2PlanCacheTable
ss2PlanCacheTable
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2PlanCacheTable
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.23
Node type: OBJECT-TYPE
Access: not-accessible
Description:
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.
OID Breakdown
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | BIANCA-BRICK-PPP-MIB |
| 1.3.6 | dod | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1 | internet | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1.4 | private | BIANCA-BRICK-PPP-MIB |
| 1.3.6.1.4.1 | enterprises | ANIROOT-MIB |
| 1.3.6.1.4.1.9600 | wtcs | WTCS |
| 1.3.6.1.4.1.9600.1 | informant | WTCS |
| 1.3.6.1.4.1.9600.1.13 | sqlServerV2 | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2 | sqlServerEngineV2 | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.23 | ss2PlanCacheTable | INFORMANT-SQLSERVER-V2 |