You can configure Network Performance Monitor to monitor alerts generated by SQL Server.

Prerequisites

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 tries to fill the parts that are missing:
    • If Provider is missing, the plug-in uses Provider=sqloledb;
    • If Server is missing, the plug-in uses 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. After you select the option, enter your username and password for the server.
  • Log entry severity range. Network Performance Monitor only monitor alerts that match the severity range entered in these boxes.
  • Only track log entries since last poll. Select this option to have Network Performance Monitor track only those alerts that occurred since the last poll.
  • Log entry threshold. The maximum number of alerts generated by the SQL Server that Network Performance Monitor allows before considering the monitor fails.