Page 181 - DCAP508_DATABASE_ADMINISTRATION

Unit 12: Tools and Techniques for Monitoring Performance

Access databases. Notes
View server and database configuration parameters.

12.10.1 SNMP Terminology

Simple Network Management Protocol (SNMP) terms are defined in the following table.

Term Description
SNMP An application that monitors the status and performance of Microsoft® SQL Server™
installations, explores defined databases, and views server and database configuration
parameters.
SNMP agent SQL Server SNMP extension agent (Sqlsnmp.dll). Server software that extends the
functionality of the SNMP service. The SNMP agent processes requests for data and
data objects that reside on the local server.

12.11 Enabling SQL Server Support of SNMP on Windows 98

You can monitor remote connections to computers running Microsoft® Windows® 98 if your
network uses Simple Network Management Protocol (SNMP).
The database controlled by an 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. SNMP can be
activated or deactivated at any time by selecting the Enable SNMP check box in the SQL Server
Network Utility dialog box.

12.12 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.
12.13 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.

LOVELY PROFESSIONAL UNIVERSITY 175