All MIBs › MSSQLSERVER-MIB › mssqlSrvInfoCacheHitRatio
mssqlSrvInfoCacheHitRatio
Module: MSSQLSERVER-MIB
OID (symbolic): MSSQLSERVER-MIB::mssqlSrvInfoCacheHitRatio
OID (numeric): 1.3.6.1.4.1.311.1.4.1.1.2.1.11
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: The percentage of time that a requested data page was found in the data cache (instead of being read from disk).
What is mssqlSrvInfoCacheHitRatio?
This read-only Gauge OID reports the percentage of data page requests satisfied from the buffer cache instead of disk; a DBA watches for this ratio dropping as a sign the server needs more memory allocated to SQL Server.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.311.1.4.1.1.2.1.11 snmpwalk -v2c -c public <target> MSSQLSERVER-MIB::mssqlSrvInfoCacheHitRatio
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.311.1.4.1.1.2.1.11.1 snmpget -v2c -c public <target> MSSQLSERVER-MIB::mssqlSrvInfoCacheHitRatio.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> mssqlSrvInfoCacheHitRatio.1
Start monitoring Windows servers running Microsoft SQL Server with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the MSSQLSERVER-MIB::mssqlSrvInfoCacheHitRatio OID value, configure state conditions and alerts, and monitor any Windows servers running Microsoft SQL Server from a single console.
OID Breakdown
Upper-level ancestors (8 from the standard OID tree / other modules)
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | AirPair-MIB |
| 1.3.6 | dod | AirPair-MIB |
| 1.3.6.1 | internet | AirPair-MIB |
| 1.3.6.1.4 | private | AirPair-MIB |
| 1.3.6.1.4.1 | enterprises | AirPair-MIB |
| 1.3.6.1.4.1.311 | microsoft | InternetServer-MIB |
| 1.3.6.1.4.1.311.1 | software | InternetServer-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.311.1.4 | apps | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1 | mssqlServer | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1 | mssqlServerObjects | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.2 | mssqlSrvInfoTable | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.2.1 | mssqlSrvInfoEntry | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.2.1.11 | mssqlSrvInfoCacheHitRatio | MSSQLSERVER-MIB |