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 |