Example: SQL Server Monitor

The following example describes how to use the WhatsUp Gold web interface to monitor CPU utilization on a SQL Server 2000 device:

  1. In the WhatsUp Gold web interface, go to Admin > Monitors. The Monitor Library appears.
  2. Select the Active tab. The Active Monitor Library appears.
  3. Click New. The Select Active Monitor Type dialog appears.
  4. Select SQL Server 2000 Monitor, then click OK. The New SQL Server 2000 Monitor dialog appears.
  5. Enter SQLCPU in the Name box.
  6. Enter the name of your database in the SQL Server instance name box.
  7. Verify that CPU is the only parameter selected in the Thresholds to monitor section.
  8. Select the CPU parameter, then click Configure. The CPU Threshold dialog appears.
  9. Enter a CPU percentage threshold into the Processor utilization must not be above box.
  10. Click OK to return to the New SQL Server 2000 Monitor dialog.
  11. Click OK to return to the Active Monitor Library dialog.
  12. Add the monitor to your SQL server device.
    • In the device list, select the device that represents the SQL server. Right-click the device, then click Properties. Click Active Monitors.
    • Click Add. The Active Monitor wizard appears.
    • Select the SQLCPU monitor and continue with the wizard to configure actions for the monitor. For more information on setting up an action, see Configuring an action.

    Note: After you complete the wizard, the monitor immediately begins to monitor the SQL Server 2000 device.

See Also

Adding and editing a SQL Server 2000 monitor

Getting Started with SQL Server Monitors

SQL Server Parameters

SQL Server Services