MSSQLSERVER-MIB

All MIBs › MSSQLSERVER-MIB

Category: Microsoft Server Agents

Description: Monitors Microsoft SQL Server database instance health, connections, and queries.

Start monitoring vendor-neutral, standards-based MIB, any SNMPv3-capable network device (SNMP engine identity/boot/clock status) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.

What Is MSSQLSERVER-MIB?

MSSQLSERVER-MIB is a vendor MIB for monitoring Microsoft SQL Server database instances via SNMP, translating database-server health into manageable objects for network/systems management tools. It typically exposes data covering SQL Server instance status, active connection counts, query/transaction throughput, and configuration parameters for the database engine. Its core monitoring purpose is software/service health: tracking whether the SQL Server service/process is running, current connection and session load, query performance counters, and potentially error or alert conditions, giving operators an at-a-glance view of database server health alongside general host metrics like CPU and memory. It commonly complements host-level MIBs (such as HOST-RESOURCES-MIB or a Windows system MIB) since SQL Server's own resource consumption is best understood together with underlying OS resource data. It is deployed on Windows servers running Microsoft SQL Server in enterprise data-center or branch-office environments where SNMP-based database monitoring is preferred over agent-based APM tools. Engineers can download the MSSQLSERVER-MIB file directly to load it into their MIB browser.

IPNetwork Monitor allows you to monitor SNMP objects defined in MSSQLSERVER-MIB. Use the built-in SNMP Monitoring Browser to explore available variables, view their current values and descriptions, and select the objects you want to monitor. You can then create SNMP monitors, configure thresholds, and receive alerts when monitored values change.

Supported Devices

Windows server running Microsoft SQL Server

Monitoring Examples

An administrator would poll a SQL Server instance status object to confirm the service is up, alongside a connections table tracking current active/blocked connections, revealing a spike in blocked sessions that signals lock contention. Cross-referencing query throughput or slow-query counters with host CPU/memory data (from a companion MIB) helps distinguish a database-level bottleneck from underlying server resource exhaustion.

What Can Be Monitored

SQL Server service/instance status
active connection/session count
query/transaction throughput
database engine configuration parameters
error/alert conditions

Imported Objects

From RFC-1212

OBJECT-TYPE

From RFC1155-SMI

Counter
Gauge
enterprises

From RFC1213-MIB

DisplayString

OIDs

OID symbolic	OID numeric	Type	Access	Description
microsoft	1.3.6.1.4.1.311
software	1.3.6.1.4.1.311.1
apps	1.3.6.1.4.1.311.1.4
mssqlServer	1.3.6.1.4.1.311.1.4.1
mssqlServerObjects	1.3.6.1.4.1.311.1.4.1.1
mssqlSrvTable	1.3.6.1.4.1.311.1.4.1.1.1		not-accessible	This table contains a single row for the SQL Server installed on the system.
mssqlSrvEntry	1.3.6.1.4.1.311.1.4.1.1.1.1		not-accessible	mssqlSrvTable entries.
STR mssqlSrvVendorName	1.3.6.1.4.1.311.1.4.1.1.1.1.1	DisplayString	read-only	The name of the database server vendor.
STR mssqlSrvProductName	1.3.6.1.4.1.311.1.4.1.1.1.1.2	DisplayString	read-only	The product name of the database server.
STR mssqlSrvVersion	1.3.6.1.4.1.311.1.4.1.1.1.1.3	DisplayString	read-only	The version of installed SQL Server.
STR mssqlSrvContact	1.3.6.1.4.1.311.1.4.1.1.1.1.4	DisplayString	read-only	Contact person for this SQL Server installation.
INT mssqlSrvState	1.3.6.1.4.1.311.1.4.1.1.1.1.5	INTEGER	read-only	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.
mssqlSrvInfoTable	1.3.6.1.4.1.311.1.4.1.1.2		not-accessible	This table contains general information regarding the active SQL Server process, including performance counters.
mssqlSrvInfoEntry	1.3.6.1.4.1.311.1.4.1.1.2.1		not-accessible	mssqlSrvInfoTable entries.
STR mssqlSrvInfoServerName	1.3.6.1.4.1.311.1.4.1.1.2.1.1	DisplayString	read-only	The name of the local SQL Server.
STR mssqlSrvInfoStartupTime	1.3.6.1.4.1.311.1.4.1.1.2.1.2	DisplayString	read-only	The date and time at which the current running SQL Server process was last started.
GAU mssqlSrvInfoTrans	1.3.6.1.4.1.311.1.4.1.1.2.1.3	Gauge	read-only	The number of command batches completed since SQL Server was last started.
CTR mssqlSrvInfoPageReads	1.3.6.1.4.1.311.1.4.1.1.2.1.4	Counter	read-only	The number of physical page reads completed since SQL Server was started.
CTR mssqlSrvInfoSinglePageWrites	1.3.6.1.4.1.311.1.4.1.1.2.1.5	Counter	read-only	The number of single page writes completed since the SQL Server was started (does not include log writes, cache flushes (Lazy Writer), or batch writes).
CTR mssqlSrvInfoBatchWrites	1.3.6.1.4.1.311.1.4.1.1.2.1.6	Counter	read-only	The number of pages written to disk using batch I/O since SQL Server was started.
CTR mssqlSrvInfoLazyWrites	1.3.6.1.4.1.311.1.4.1.1.2.1.7	Counter	read-only	The number of pages flushed to disk by the Lazy Writer since SQL Server was started.
CTR mssqlSrvInfoLogWrites	1.3.6.1.4.1.311.1.4.1.1.2.1.8	Counter	read-only	The number of log pages physically written to disk since SQL Server was started.
CTR mssqlSrvInfoOutstandingReads	1.3.6.1.4.1.311.1.4.1.1.2.1.9	Counter	read-only	The number of physical reads pending.
CTR mssqlSrvInfoOutstandingWrites	1.3.6.1.4.1.311.1.4.1.1.2.1.10	Counter	read-only	The number of physical writes pending.
GAU mssqlSrvInfoCacheHitRatio	1.3.6.1.4.1.311.1.4.1.1.2.1.11	Gauge	read-only	The percentage of time that a requested data page was found in the data cache (instead of being read from disk).
GAU mssqlSrvInfoFreeBuffers	1.3.6.1.4.1.311.1.4.1.1.2.1.12	Gauge	read-only	The number of data cache buffers currently in the free pool.
CTR mssqlSrvInfoNetworkReads	1.3.6.1.4.1.311.1.4.1.1.2.1.13	Counter	read-only	The number of tabular data stream (TDS) packets read from the network since SQL Server was started.
CTR mssqlSrvInfoNetworkWrites	1.3.6.1.4.1.311.1.4.1.1.2.1.14	Counter	read-only	The number of tabular data stream (TDS) packets written to the network since SQL Server was started.
CTR mssqlSrvInfoRAPhysicalReads	1.3.6.1.4.1.311.1.4.1.1.2.1.15	Counter	read-only	Physical reads (each consisting of 8 - 2K pages) issued by Read Ahead Manager since SQL Server was started.
GAU mssqlSrvInfoUserConnections	1.3.6.1.4.1.311.1.4.1.1.2.1.16	Gauge	read-only	The number of open user connections.
GAU mssqlSrvInfoTotalLocks	1.3.6.1.4.1.311.1.4.1.1.2.1.17	Gauge	read-only	A count of all locks being used by SQL Server.
GAU mssqlSrvInfoTotalBlockingLocks	1.3.6.1.4.1.311.1.4.1.1.2.1.18	Gauge	read-only	A count of all locks blocking other processes.
GAU mssqlSrvInfoUsersBlocked	1.3.6.1.4.1.311.1.4.1.1.2.1.19	Gauge	read-only	The number of users blocked by other users.
mssqlSrvConfigParamTable	1.3.6.1.4.1.311.1.4.1.1.3		not-accessible	This table contains entries for the SQL Server configuration parameters.
mssqlSrvConfigParamEntry	1.3.6.1.4.1.311.1.4.1.1.3.1		not-accessible	mssqlSrvConfigParamTable entries. The SQL Server configuration parameter name is used as the index value.
STR mssqlSrvConfigParamName	1.3.6.1.4.1.311.1.4.1.1.3.1.1	DisplayString	read-only	Name of SQL Server configuration parameter.
INT mssqlSrvConfigParamMax	1.3.6.1.4.1.311.1.4.1.1.3.1.2	INTEGER	read-only	The maximum configurable value for the associated SQL Server configuration parameter.
INT mssqlSrvConfigParamMin	1.3.6.1.4.1.311.1.4.1.1.3.1.3	INTEGER	read-only	The minimum configurable value for the associated SQL Server configuration parameter.
INT mssqlSrvConfigParamConfigValue	1.3.6.1.4.1.311.1.4.1.1.3.1.4	INTEGER	read-only	The current configured value for the associated SQL Server configuration parameter.
INT mssqlSrvConfigParamRunValue	1.3.6.1.4.1.311.1.4.1.1.3.1.5	INTEGER	read-only	The current run value for the associated SQL Server configuration parameter.
mssqlSrvDeviceTable	1.3.6.1.4.1.311.1.4.1.1.4		not-accessible	This table contains entries for each SQL Server device on the system.
mssqlSrvDeviceEntry	1.3.6.1.4.1.311.1.4.1.1.4.1		not-accessible	mssqlSrvDeviceTable entries.
STR mssqlSrvDeviceLogicalName	1.3.6.1.4.1.311.1.4.1.1.4.1.1	DisplayString	read-only	The logical name of the defined database or dump device.
STR mssqlSrvDevicePhysicalName	1.3.6.1.4.1.311.1.4.1.1.4.1.2	DisplayString	read-only	The physical name including the file system path and file name.
STR mssqlSrvDeviceDescription	1.3.6.1.4.1.311.1.4.1.1.4.1.3	DisplayString	read-only	Detailed description of the device including the type of device, size, and the media type.
mssqlDbTable	1.3.6.1.4.1.311.1.4.1.1.5		not-accessible	This table contains a list of SQL Server databases. The table contains a single row for each database (whether the database is actually accessible or not).
mssqlDbEntry	1.3.6.1.4.1.311.1.4.1.1.5.1		not-accessible	mssqlDbTable entries.
INT mssqlDbId	1.3.6.1.4.1.311.1.4.1.1.5.1.1	INTEGER	read-only	The dbid of the database.
STR mssqlDbName	1.3.6.1.4.1.311.1.4.1.1.5.1.2	DisplayString	read-only	The name of the database.
INT mssqlDbState	1.3.6.1.4.1.311.1.4.1.1.5.1.3	INTEGER	read-only	The state of the database. Valid states are defined as follows: Active(1), Single User(2), DBO Only(3), Read Only(4), Offline(5), Suspect(6), Loading(7), and Publishing(8).
mssqlDbInfoTable	1.3.6.1.4.1.311.1.4.1.1.6		not-accessible	This table contains detailed information about SQL Server databases. In order for this table to be populated, the database must be accessible (as determined by checking mssqlDbState).
mssqlDbInfoEntry	1.3.6.1.4.1.311.1.4.1.1.6.1		not-accessible	mssqlDbInfoTable entries.
INT mssqlDbInfoDbId	1.3.6.1.4.1.311.1.4.1.1.6.1.1	INTEGER	read-only	The dbid of the database associated with this row.
STR mssqlDbInfoDbName	1.3.6.1.4.1.311.1.4.1.1.6.1.2	DisplayString	read-only	The name of the database associated with this row.
STR mssqlDbInfoCreationDateTime	1.3.6.1.4.1.311.1.4.1.1.6.1.3	DisplayString	read-only	The date and time that the database associated with this row was created.
STR mssqlDbInfoOwner	1.3.6.1.4.1.311.1.4.1.1.6.1.4	DisplayString	read-only	The owner of the database associated with this row.
INT mssqlDbInfoSize	1.3.6.1.4.1.311.1.4.1.1.6.1.5	INTEGER	read-only	The size in KB of the database associated with this row.
INT mssqlDbInfoUnallocatedSpace	1.3.6.1.4.1.311.1.4.1.1.6.1.6	INTEGER	read-only	The unallocated space in KB of the database associated with this row.
INT mssqlDbInfoReservedSpace	1.3.6.1.4.1.311.1.4.1.1.6.1.7	INTEGER	read-only	The reserved space in KB of the database associated with this row.
INT mssqlDbInfoDataSpace	1.3.6.1.4.1.311.1.4.1.1.6.1.8	INTEGER	read-only	The used data space in KB of the database associated with this row.
INT mssqlDbInfoIndexSpace	1.3.6.1.4.1.311.1.4.1.1.6.1.9	INTEGER	read-only	The used index space in KB of the database associated with this row.
INT mssqlDbInfoUnusedSpace	1.3.6.1.4.1.311.1.4.1.1.6.1.10	INTEGER	read-only	The unused space in KB of the database associated with this row.
STR mssqlDbInfoLastTrLogDump	1.3.6.1.4.1.311.1.4.1.1.6.1.11	DisplayString	read-only	The date and time that the latest transaction log dump for this database was taken.
INT mssqlDbInfoLogSize	1.3.6.1.4.1.311.1.4.1.1.6.1.12	INTEGER	read-only	The size in KB of the transaction log for the database associated with this row.
INT mssqlDbInfoLogSpaceUsed	1.3.6.1.4.1.311.1.4.1.1.6.1.13	INTEGER	read-only	The percentage of transaction log space for the database associated with this row.
mssqlDbOptionTable	1.3.6.1.4.1.311.1.4.1.1.7		not-accessible	This table contains the list of possible database options and indicates which are set for a given dastabase.
mssqlDbOptionEntry	1.3.6.1.4.1.311.1.4.1.1.7.1		not-accessible	mssqlDbOptionTable entries. The dbid of the database is used as the index value associated with this row.
INT mssqlDbOptionDbId	1.3.6.1.4.1.311.1.4.1.1.7.1.1	INTEGER	read-only	The dbid of the database associated with this row.
STR mssqlDbOptionDbName	1.3.6.1.4.1.311.1.4.1.1.7.1.2	DisplayString	read-only	The name of the database associated with this row.
STR mssqlDbOptionSetName	1.3.6.1.4.1.311.1.4.1.1.7.1.3	DisplayString	read-only	The name of the database option that is set for the database associated with this row.
INT pysmiFakeCol948	1.3.6.1.4.1.311.1.4.1.1.7.1.4294967295	INTEGER	not-accessible
mssqlDbDeviceTable	1.3.6.1.4.1.311.1.4.1.1.8		not-accessible	This table contains entries for each device fragment on which a particular SQL Server database has been created or altered.
mssqlDbDeviceEntry	1.3.6.1.4.1.311.1.4.1.1.8.1		not-accessible	mssqlDbDeviceTable entries. The dbid of the database is used as index value associated with this row.
INT mssqlDbDeviceDbId	1.3.6.1.4.1.311.1.4.1.1.8.1.1	INTEGER	read-only	The dbid of the database associated with this row.
STR mssqlDbDeviceDbName	1.3.6.1.4.1.311.1.4.1.1.8.1.2	DisplayString	read-only	The name of the database associated with this row.
STR mssqlDbDeviceFragmentName	1.3.6.1.4.1.311.1.4.1.1.8.1.3	DisplayString	read-only	The name of a device fragment on which the database has been created or altered.
INT mssqlDbDeviceFragmentSize	1.3.6.1.4.1.311.1.4.1.1.8.1.4	INTEGER	read-only	The size in KB of the device fragment on which the database has been created or altered.
STR mssqlDbDeviceFragmentUsage	1.3.6.1.4.1.311.1.4.1.1.8.1.5	DisplayString	read-only	Indicates if the device fragment contains data, log, or data and log.
INT pysmiFakeCol949	1.3.6.1.4.1.311.1.4.1.1.8.1.4294967295	INTEGER	not-accessible

RFC description

Microsoft SQL Server database instance information including vendor, version, and status.

Start monitoring Windows servers running Microsoft SQL Server with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.

Download MSSQLSERVER-MIB

What Is MSSQLSERVER-MIB?

Supported Devices

Monitoring Examples

What Can Be Monitored

This MIB depends on

RFC description