Enabling SQL Server MIB

Administering SQL Server

Administering SQL Server

Enabling SQL Server MIB

The database controlled by a Simple Network Management Protocol (SNMP) agent is known as SNMP Management Information Base (MIB). The values contained in an SNMP MIB can be shared with the SNMP MIB of another application.

Microsoft® SQL Server™ Management Information Base (MSSQL-MIB), stored in the Mssql.mib file, and the SQL Server SNMP extension agent (Sqlsnmp.dll) are copied to the system by SQL Server Setup and are enabled if SNMP is running at the time of installation.

For more information about SNMP, see the SNMP application documentation.

Copying the MSSQL-MIB to an SNMP Workstation

For SNMP applications to monitor the status of a SQL Server installation, a copy of MSSQL-MIB, stored in the Mssql.mib file, must be placed on the monitoring workstation and loaded into the SNMP application. MSSQL-MIB enables the SNMP application to access and monitor the SQL Server SNMP extension agent on an instance of 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.

The following table describes the SNMP tables. 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 installation of SQL Server version 6.5 or earlier or multiple rows for each instance of SQL Server version 7.0 or SQL Server 2000 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.
MssqlDbOptionTable Lists database options set for each SQL Server database.

For more information, see the SNMP application documentation.

To copy the SQL Server MSSQL-MIB to an SNMP workstation