All MIBs › MSSQLSERVER-MIB › mssqlSrvState
mssqlSrvState
Module: MSSQLSERVER-MIB
OID (symbolic): MSSQLSERVER-MIB::mssqlSrvState
OID (numeric): 1.3.6.1.4.1.311.1.4.1.1.1.1.5
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: The state of SQL Server. Unknown(1) means we are unable to determine the state of the server, Running(2) means the server is available and can be used, Paused(3) means the server is running, but new connections cannot currently be established, and Stopped(4) means the server is not running and unavailable.
What is mssqlSrvState?
This read-only OID reports the current lifecycle state of the SQL Server process, such as running, paused, stopped, starting, stopping, continuing, or pausing. A monitoring system alerts when this value isn't 'running' since that means client connections may fail or new ones can't be established.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.311.1.4.1.1.1.1.5 snmpwalk -v2c -c public <target> MSSQLSERVER-MIB::mssqlSrvState
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.311.1.4.1.1.1.1.5.1 snmpget -v2c -c public <target> MSSQLSERVER-MIB::mssqlSrvState.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> mssqlSrvState.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::mssqlSrvState 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.1 | mssqlSrvTable | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.1.1 | mssqlSrvEntry | MSSQLSERVER-MIB |
| 1.3.6.1.4.1.311.1.4.1.1.1.1.5 | mssqlSrvState | MSSQLSERVER-MIB |