All MIBs › INFORMANT-SQLSERVER-V2 › ss2sqsSQLReCompilationsPerSec
ss2sqsSQLReCompilationsPerSec
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2sqsSQLReCompilationsPerSec
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.31.1.9
Node type: OBJECT-TYPE
Type: Gauge32
Access: read-only
Description:
Number of SQL re-compiles.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.31.1.9 snmpwalk -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2sqsSQLReCompilationsPerSec
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.31.1.9.1 snmpget -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2sqsSQLReCompilationsPerSec.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> ss2sqsSQLReCompilationsPerSec.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.9 | ss2sqsSQLReCompilationsPerSec | INFORMANT-SQLSERVER-V2 |