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:
- Go to the Configuration tab. Under Alerts and metrics, select Custom metrics:
- Click the Create custom metric button: