The MSSQL.MIB file is a text file that contains the definitions of objects that are available to management workstations. The file consists of read-only variables for monitoring general performance counters, the statuses of SQL Servers and databases, and limited discovery of configuration options and devices. MSSQL.MIB does not define any writeable objects.
The MSSQL.MIB file includes the following tables. Note that 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 SQL Server (version 6.0 or later) installed on the server computer. |
| mssqlSrvInfoTable | Contains general information about the active SQL Server process, including performance counters. |
| mssqlSrvConfigParamTable | Lists the SQL Server configuration parameters. |
| mssqlSrvDeviceTable | Contains an entry for each SQL Server device that is defined on the system. |
| mssqlDbTable | Lists SQL Server databases that are defined. Contains a single row for each database. |
| mssqlDbInfoTable | Contains detailed information about each SQL Server database. |
| mssqlDbOptionTable | Lists the database options that are set for each database. |
| mssqlDbDeviceTable | Contains entries for each device fragment on which a particular SQL Server database has been created or altered. |