For Simple Network Management Protocol (SNMP) applications to monitor the status of a Microsoft® SQL Server™ installation, a copy of the Microsoft SQL Server Management Information Base (MSSQL-MIB), stored in the Mssql.mib file, must be placed on the monitoring workstation and loaded into the SNMP application. The MSSQL-MIB enables the SNMP application to access the SQL Server SNMP extension agent on the computer running SQL Server, and monitor that SQL Server.
The Mssql.mib file is a text file that contains the definitions of objects available to SNMP workstations. The file consists of read-only variables for monitoring general performance counters, the status of SQL Server installation and databases, and limited discovery of configuration options and database files. Mssql.mib does not define any writable objects.
These tables are SNMP tables, not SQL Server tables.
SNMP table | Description |
---|---|
MssqlSrvTable | Contains a description of the SQL Server installation. Has a single row for each SQL Server installation (version 6.5 or earlier) or multiple rows for each SQL Server (version 7.0 or later) running on the server. |
MssqlSrvInfoTable | Contains general information about the active SQL Server process, including performance counters. |
MssqlSrvConfigParamTable | Lists SQL Server configuration parameters. |
MssqlSrvDeviceTable | Contains an entry for each SQL Server database file defined on the system. |
MssqlDbTable | Lists defined SQL Server databases. Contains a single row for each database. |
MssqlDbInfoTable | Contains detailed information about each SQL Server database. |
MssqlDbOptionTable | Lists database options set for each SQL Server database. |
MssqlDbDeviceTable | Contains entries for each device fragment on which a particular SQL Server 6.5 database has been created or altered. For SQL Server 7.0 entries will be displayed for each database file found on the server. |
For more information, see your SNMP application documentation.
To copy the SQL Server MSSQL-MIB to an SNMP workstation