Configure Log Threshold

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

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

• DSN. This field controls the connection to the DSN configured for the SQL server. The following show the proper way to structure entries for this field:

  You can enter just the DSN. Ex: Whatsup

  You can specify the DSN in the form of DSN=Whatsup as well.

  This field also works as a connection string that you can specify for the connection to the SQL server. Ex: Provider=sqloledb.2;Server=ARNOR\WHATSUP

  If you specify the DSN, the plugin will use the field 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 specify a DSN, the monitor connects to the SQL server configured with the DSN and not necessarily the device the monitor is attached to. If you leave the field blank, the connection is constructed depending on the device so that you can use one SQL monitor and assign it to more than one device.

  If you enter a connection string and not a DSN name, the plugin will try to fill the parts that are missing:

  If Provider is missing, the plugin will use Provider=sqloledb;

  If Server is missing the plugin will use Server=<the device's IP address>\<the specified instance on 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 error log entries 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 error log entries that occurred since the last poll.  
• Log entry threshold. The maximum number of error log entries generated by the SQL Server that WhatsUp Gold allows before considering the monitor will fail.