SQL Monitor - 3.2

SQL Monitor

Creating custom metrics and alerts - SQL Monitor

Note: If you don't want to create a custom metric and alert from scratch, we've provided a website containing a range of metrics that you can install automatically. See http://sqlmonitormetrics.red-gate.com/.

To create a custom metric:

  1. Go to the Configuration tab. Under Alerts and metrics, select Custom metrics:

    AlertsandMetricsConfigPage

  2. Click the Create custom metric button:

    CreateCustomMetricButton

The first page of a simple, three-step wizard is displayed. The steps are:

Step 1. Define metric - includes sections for defining the metric, and entering and testing the T-SQL query on which the metric is based.

Step 2. Add an alert - optionally base an alert on the metric by completing sections similar to those displayed on the Alert settings page (Configuration > Alert settings).

Step 3. Create - creates the custom metric and alert.

Was this article helpful?

Search support
Forums
Visit the SQL Monitor forum.