A MIB is a standardized file that defines the data that is sent to the Network Management Console in the SNMP Trap events generated by SQL Diagnostic Manager.

SNMP traps enable an agent to spontaneously inform the management station of significant events by way of an unsolicited SNMP message. Traps are suitable when there is a large number of devices and each device has a large number of objects.

Note that in order for a management system to interpret a trap sent to it by an agent, it needs to have the MIB for that trap loaded.

The MIB file (Idera.MIB) defines the following data:

Name

OID

Syntax

Description

Alert Summary

.1.3.6.1.4.1.24117.1.2.1

DisplayString

Summary text of the alert

Alert Text

.1.3.6.1.4.1.24117.1.2.2

DisplayString

Full text description of the alert

Metric

.1.3.6.1.4.1.24117.1.2.3

DisplayString

SQLdm metric that triggered the alert

Severity

.1.3.6.1.4.1.24117.1.2.4

DisplayString

Severity of the alert

Instance

.1.3.6.1.4.1.24117.1.2.5

DisplayString

The SQL server instance that triggered the alert

Database

.1.3.6.1.4.1.24117.1.2.6

DisplayString

If applicable to the alert, the database that triggered the alert

Table

.1.3.6.1.4.1.24117.1.2.7

DisplayString

If applicable to the alert, the table that triggered the alert

Timestamp

.1.3.6.1.4.1.24117.1.2.8

DisplayString

The date and time that the alert was detected

Value

.1.3.6.1.4.1.24117.1.2.9

DisplayString

The value detected for the specific metric

Description

.1.3.6.1.4.1.24117.1.2.10

DisplayString

Description of metric

Comments

.1.3.6.1.4.1.24117.1.2.11

DisplayString

User specified comments pertaining to the metric




SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal