Configuring alerts threshold

You can configure WhatsUp Gold to monitor alerts generated by SQL Server.

Note: Before the alert can be monitored, you must configure your System Data Source (ODBC) name for the SQL Server.

• DSN. This box controls the connection to the DSN configured for the SQL server. The following show the proper way to structure entries for this box:
  • You can enter just the DSN. For example:  Whatsup
  • You can specify the DSN in the form of DSN=Whatsup as well.
  • This box also works as a connection string that you can specify for the connection to the SQL server.

    For example:  Provider=sqloledb.2;Server=ARNOR\WHATSUP

  • If you specify the DSN the plug-in will use the box as is. If you leave it blank, the monitor uses the following string to connect:

    Provider=sqloledb;Server=<the device's IP address>\<the specified instance on the main dialog>;

  • If you enter a connection string not a DSN name, the plug-in will try to fill the parts that are missing:
    • If Provider is missing, the plug-in will use Provider=sqloledb;
    • If Server is missing the plug-in will use Server=<the device's IP address>\<the specified instance of the main dialog>;
• Use SQL Server Authentication. Select this option to use SQL Server Authentication to connect to your database for the monitor. If this option is not used, the connection is made by the settings in the DSN, or with the windows credentials configured for the device the monitor is assigned to. Once the option is selected, enter your username and password for the server.
• Log entry severity range. WhatsUp Gold will only monitor alerts that match the severity range entered in these boxes.
• Only track log entries since last poll. Select this option to have WhatsUp Gold track only those alerts that occurred since the last poll.  
• Log entry threshold. The maximum number of alerts generated by the SQL Server that WhatsUp Gold allows before considering the monitor will fail.