Monitor/Service Properties

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.

Name. The name as it will appear in the Active Monitor Library.
Description. Enter a short description of the monitor. This is displayed in the Active Monitor Library along with the entry in with the Name box.
SQL Server instance name. Enter the server instance name. Ipswitch WhatsUp Gold v11 uses WHATSUP as the default instance.

Thresholds to monitor

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.

Services to monitor

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.

Use in discovery. When this option is selected, WhatsUp Gold adds the monitor to the Active Monitors list. From that list, you can select to scan for that service on all applications found during discovery.

<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 monitor.