MSSQLSERVER-MIB: View SNMP OID List / Download MIB

VENDOR: MICROSOFT


 Home MIB: MSSQLSERVER-MIB
Download as:   
SNMPv2-CONF, SNMPv2-SMI, SNMPv2-TC

Download standard MIB format if you are planning to load a MIB file into some system (OS, Zabbix, PRTG ...) or view it with a MIB browser. CSV is more suitable for analyzing and viewing OID' and other MIB objects in excel. JSON and YAML formats are usually used in programing even though some systems can use MIB in YAML format (like Logstash).
Keep in mind that standard MIB files can be successfully loaded by systems and programs only if all the required MIB's from the "Imports" section are already loaded.
The tree-like SNMP object navigator requires no explanations because it is very simple to use. And if you stumbled on this MIB from Google note that you can always go back to the home page if you need to perform another MIB or OID lookup.


Object Name OID Type Access Info
 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 no-access
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 no-access
mssqlSrvTable entries.
                                 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.
                                 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.
                                 mssqlSrvVersion 1.3.6.1.4.1.311.1.4.1.1.1.1.3 displaystring read-only
The version of installed SQL Server.
                                 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.
                                 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. Enumeration: 'paused': 2, 'continuing': 6, 'pausing': 7, 'running': 1, 'stopped': 3, 'stopping': 5, 'starting': 4.
                         mssqlSrvInfoTable 1.3.6.1.4.1.311.1.4.1.1.2 no-access
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 no-access
mssqlSrvInfoTable entries.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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).
                                 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.
                                 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.
                                 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.
                                 mssqlSrvInfoOutstandingReads 1.3.6.1.4.1.311.1.4.1.1.2.1.9 counter read-only
The number of physical reads pending.
                                 mssqlSrvInfoOutstandingWrites 1.3.6.1.4.1.311.1.4.1.1.2.1.10 counter read-only
The number of physical writes pending.
                                 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).
                                 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.
                                 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.
                                 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.
                                 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.
                                 mssqlSrvInfoUserConnections 1.3.6.1.4.1.311.1.4.1.1.2.1.16 gauge read-only
The number of open user connections.
                                 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.
                                 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.
                                 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 no-access
This table contains entries for the SQL Server configuration parameters.
                             mssqlSrvConfigParamEntry 1.3.6.1.4.1.311.1.4.1.1.3.1 no-access
mssqlSrvConfigParamTable entries. The SQL Server configuration parameter name is used as the index value.
                                 mssqlSrvConfigParamName 1.3.6.1.4.1.311.1.4.1.1.3.1.1 displaystring read-only
Name of SQL Server configuration parameter.
                                 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.
                                 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.
                                 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.
                                 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 no-access
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 no-access
mssqlSrvDeviceTable entries.
                                 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.
                                 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.
                                 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 no-access
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 no-access
mssqlDbTable entries.
                                 mssqlDbId 1.3.6.1.4.1.311.1.4.1.1.5.1.1 integer read-only
The dbid of the database.
                                 mssqlDbName 1.3.6.1.4.1.311.1.4.1.1.5.1.2 displaystring read-only
The name of the database.
                                 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). Enumeration: 'loading': 7, 'publishing': 8, 'dboonly': 3, 'singleUser': 2, 'readOnly': 4, 'suspect': 6, 'active': 1, 'offline': 5.
                         mssqlDbInfoTable 1.3.6.1.4.1.311.1.4.1.1.6 no-access
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 no-access
mssqlDbInfoTable entries.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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 no-access
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 no-access
mssqlDbOptionTable entries. The dbid of the database is used as the index value associated with this row.
                                 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.
                                 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.
                                 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.
                         mssqlDbDeviceTable 1.3.6.1.4.1.311.1.4.1.1.8 no-access
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 no-access
mssqlDbDeviceTable entries. The dbid of the database is used as index value associated with this row.
                                 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.
                                 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.
                                 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.
                                 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.
                                 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.