All MIBs › INFORMANT-SQLSERVER-V2 › ss2sqsMisguidedPlanExecutionsSec
ss2sqsMisguidedPlanExecutionsSec
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2sqsMisguidedPlanExecutionsSec
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.31.1.6
Node type: OBJECT-TYPE
Type: Gauge32
Access: read-only
Description:
Number of plan executions second in which a plan guide could not be honored during plan generation. The plan guide was disregarded and normal compilation was used to generate the executed plan.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.31.1.6 snmpwalk -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2sqsMisguidedPlanExecutionsSec
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.31.1.6.1 snmpget -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2sqsMisguidedPlanExecutionsSec.1
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.31 | ss2SQLStatisticsTable | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.31.1 | ss2SQLStatisticsEntry | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.31.1.6 | ss2sqsMisguidedPlanExecutionsSec | INFORMANT-SQLSERVER-V2 |