With this dialog, you can configure WhatsUp Gold to monitor the various parameters and processes of your SQL Server. Multiple monitors may be configured with like parameters to show where problems may be occurring with the SQL server or with the computer running the server.
Note: The WhatsUp Gold SQL Server Monitor only works with an MSDE or a Microsoft SQL Server database.
After the monitor is configured on this dialog, you must assign that monitor to a device through the Device Properties > Active Monitors dialog.
The upper-half of this dialog contains the SQL server parameters that you can select for monitoring.
To select a parameter for monitoring, click the check box to its left. Any parameter that is checked will be monitored.
To configure a threshold for a parameter, select the parameter and then click the Configure button. We have provided default threshold settings for each parameter, but you should change them according to your needs. It is best to establish a baseline value for the parameter and then use it to configure a threshold.
You can configure a threshold for a parameter whether or not the parameter is selected for monitoring.
You can also configure custom parameters by selecting the Custom Values parameter and clicking Configure. The Custom WMI Parameters dialog box appears.
The lower-half of this dialog contains the SQL services that can be monitored. To monitor these services, select the services in this dialog. There is no configuration involved because SQL reports only whether the service is Up or Down.
<Notes> You can add multiple parameters or processes to a SQL Monitor. In this case, the monitor will be "down" if any of the selected parameters exceeds a threshold or any of the processes fails.
You can use the
%ActiveMonitor.Payload notification variable to
report the status of the "aspects" of a SQL Monitor. Click here for
an example of an Active Monitor Payload from the SQL