If you don't want to create a custom metric and alert from scratch, we've provided a website, SQL Monitor Metrics, containing a range of metrics that you can install automatically.
To create a custom metric:
- Go to the Configuration tab. Under Alerts and metrics, select Custom metrics:
- Click the Create custom metric button: