Chat now with support
Chat with Support

Spotlight on SQL Server Enterprise 11.7 - Release Notes

Add alarms to custom counters

Use these instructions to add alarms to custom counters that return a numeric value, so that you are alerted when the counter values exceed their thresholds.

Prior to following these instructions, ensure you Configure | Custom Counters.

From the Spotlight Client

  1. Click Configure | Alarms.

  2. Select the connection or template to apply the alarm configuration to.
  3. Double click on the Custom Counters alarm appropriate to the connection type (SQL Custom Counters or Windows Custom Counters). The dialog to Configure an alarm opens.
  4. Clear the Factory Settings control so you can modify the settings for this alarm.
  5. Click Add to add a key value.
    1. In the Add Key dialog, select or type the key value (the Custom Counter you want to alarm on).
  6. Add severities to this key value.
    1. Ensure this key value is selected.
    2. Click Add Severity. Select the severity level to apply. Enable the new severity.
    3. Use either the colored bar or the Severity table to set thresholds. For more information, see Severity thresholds.
  7. Enter an alarm description in the Description field. When the alarm is raised, the description appears in the Details column of the Alarm log and Spotlight today and the SQL Server | Home Page or Windows Server | Home Page when you hover the mouse over the Custom Counters button.

    To include the key name and current value in the description, use the following syntax:

    {{key}} = Custom counter name

    {{value}} = Custom counter value

    Example:

    {{key}} has a value of {{value}}

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating