All MIBs › INFORMANT-SQLSERVER-V2 › ss2amWorktablesFromCacheRatio
ss2amWorktablesFromCacheRatio
Module: INFORMANT-SQLSERVER-V2
OID (symbolic): INFORMANT-SQLSERVER-V2::ss2amWorktablesFromCacheRatio
OID (numeric): 1.3.6.1.4.1.9600.1.13.2.2.1.42
Node type: OBJECT-TYPE
Type: Gauge32
Access: read-only
Description:
Percentage of work tables created where the initial two pages of the work table were not allocated but were immediately available from the work table cache.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.2.1.42 snmpwalk -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2amWorktablesFromCacheRatio
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.9600.1.13.2.2.1.42.1 snmpget -v2c -c public <target> INFORMANT-SQLSERVER-V2::ss2amWorktablesFromCacheRatio.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.2 | ss2AccessMethodsTable | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.2.1 | ss2AccessMethodsEntry | INFORMANT-SQLSERVER-V2 |
| 1.3.6.1.4.1.9600.1.13.2.2.1.42 | ss2amWorktablesFromCacheRatio | INFORMANT-SQLSERVER-V2 |