MSSQLSERVER-MIB Download

MIBs list

With the IPHost SNMP tool, you can monitor any SNMP objects of the MSSQLSERVER-MIB . You can select a variable to monitor using the built-in IPHost MIB browser that provides you with all variables, their current values and descriptions taken from the MSSQLSERVER-MIB .

OID list for MSSQLSERVER-MIB

mssqlSrvTable: This table contains a single row for the SQL Server installed on the system.
mssqlSrvEntry: mssqlSrvTable entries.
mssqlSrvVendorName: The name of the database server vendor.
mssqlSrvProductName: The product name of the database server.
mssqlSrvVersion: The version of installed SQL Server.
mssqlSrvContact: Contact person for this SQL Server installation.
mssqlSrvState: 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 Stoppe ...
mssqlSrvInfoTable: This table contains general information regarding the active SQL Server process, including performance counters.
mssqlSrvInfoEntry: mssqlSrvInfoTable entries.
mssqlSrvInfoServerName: The name of the local SQL Server.
mssqlSrvInfoStartupTime: The date and time at which the current running SQL Server process was last started.
mssqlSrvInfoTrans: The number of command batches completed since SQL Server was last started.
mssqlSrvInfoPageReads: The number of physical page reads completed since SQL Server was started.
mssqlSrvInfoSinglePageWrites: 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: The number of pages written to disk using batch I/O since SQL Server was started.
mssqlSrvInfoLazyWrites: The number of pages flushed to disk by the Lazy Writer since SQL Server was started.
mssqlSrvInfoLogWrites: The number of log pages physically written to disk since SQL Server was started.
mssqlSrvInfoOutstandingReads: The number of physical reads pending.
mssqlSrvInfoOutstandingWrites: The number of physical writes pending.
mssqlSrvInfoCacheHitRatio: The percentage of time that a requested data page was found in the data cache (instead of being read from disk).
mssqlSrvInfoFreeBuffers: The number of data cache buffers currently in the free pool.
mssqlSrvInfoNetworkReads: The number of tabular data stream (TDS) packets read from the network since SQL Server was started.
mssqlSrvInfoNetworkWrites: The number of tabular data stream (TDS) packets written to the network since SQL Server was started.
mssqlSrvInfoRAPhysicalReads: Physical reads (each consisting of 8 - 2K pages) issued by Read Ahead Manager since SQL Server was started.
mssqlSrvInfoUserConnections: The number of open user connections.
mssqlSrvInfoTotalLocks: A count of all locks being used by SQL Server.
mssqlSrvInfoTotalBlockingLocks: A count of all locks blocking other processes.
mssqlSrvInfoUsersBlocked: The number of users blocked by other users.
mssqlSrvConfigParamTable: This table contains entries for the SQL Server configuration parameters.
mssqlSrvConfigParamEntry: mssqlSrvConfigParamTable entries. The SQL Server configuration parameter name is used as the index value.
mssqlSrvConfigParamName: Name of SQL Server configuration parameter.
mssqlSrvConfigParamMax: The maximum configurable value for the associated SQL Server configuration parameter.
mssqlSrvConfigParamMin: The minimum configurable value for the associated SQL Server configuration parameter.
mssqlSrvConfigParamConfigValue: The current configured value for the associated SQL Server configuration parameter.
mssqlSrvConfigParamRunValue: The current run value for the associated SQL Server configuration parameter.
mssqlSrvDeviceTable: This table contains entries for each SQL Server device on the system.
mssqlSrvDeviceEntry: mssqlSrvDeviceTable entries.
mssqlSrvDeviceLogicalName: The logical name of the defined database or dump device.
mssqlSrvDevicePhysicalName: The physical name including the file system path and file name.
mssqlSrvDeviceDescription: Detailed description of the device including the type of device, size, and the media type.
mssqlDbTable: 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: mssqlDbTable entries.
mssqlDbId: The dbid of the database.
mssqlDbName: The name of the database.
mssqlDbState: 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: 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: mssqlDbInfoTable entries.
mssqlDbInfoDbId: The dbid of the database associated with this row.
mssqlDbInfoDbName: The name of the database associated with this row.
mssqlDbInfoCreationDateTime: The date and time that the database associated with this row was created.
mssqlDbInfoOwner: The owner of the database associated with this row.
mssqlDbInfoSize: The size in KB of the database associated with this row.
mssqlDbInfoUnallocatedSpace: The unallocated space in KB of the database associated with this row.
mssqlDbInfoReservedSpace: The reserved space in KB of the database associated with this row.
mssqlDbInfoDataSpace: The used data space in KB of the database associated with this row.
mssqlDbInfoIndexSpace: The used index space in KB of the database associated with this row.
mssqlDbInfoUnusedSpace: The unused space in KB of the database associated with this row.
mssqlDbInfoLastTrLogDump: The date and time that the latest transaction log dump for this database was taken.
mssqlDbInfoLogSize: The size in KB of the transaction log for the database associated with this row.
mssqlDbInfoLogSpaceUsed: The percentage of transaction log space for the database associated with this row.
mssqlDbOptionTable: This table contains the list of possible database options and indicates which are set for a given dastabase.
mssqlDbOptionEntry: mssqlDbOptionTable entries. The dbid of the database is used as the index value associated with this row.
mssqlDbOptionDbId: The dbid of the database associated with this row.
mssqlDbOptionDbName: The name of the database associated with this row.
mssqlDbOptionSetName: The name of the database option that is set for the database associated with this row.
mssqlDbDeviceTable: This table contains entries for each device fragment on which a particular SQL Server database has been created or altered.
mssqlDbDeviceEntry: mssqlDbDeviceTable entries. The dbid of the database is used as index value associated with this row.
mssqlDbDeviceDbId: The dbid of the database associated with this row.
mssqlDbDeviceDbName: The name of the database associated with this row.
mssqlDbDeviceFragmentName: The name of a device fragment on which the database has been created or altered.
mssqlDbDeviceFragmentSize: The size in KB of the device fragment on which the database has been created or altered.
mssqlDbDeviceFragmentUsage: Indicates if the device fragment contains data, log, or data and log.

You can start network devices monitoring using free 30-day trial version of IPHost Network Monitor right now. Witn IPHost SNMP monitor you can monitor network performance, audit network usage, detect network faults, or inappropriate access. The IPHost's SNMP monitor can communicate and interact with any SNMP-enabled device.

MIBs list