PASS Data Community Summit logo

PASS Data Community Summit 2023

Get all the latest announcements direct to your inbox

Custom metrics

If you want SQL Monitor to collect extra performance data that's particularly important for your servers, you can now add T-SQL scripts to do it.

You can analyze this data and receive alerts about it just like any other data that SQL Monitor collects.

On our dedicated custom metrics site, SQLMonitorMetrics.com, you can find and review T-SQL scripts and import them directly into your copy of SQL Monitor.

MVPs, the SQL Monitor team, MVPs, and the SQL Server community have added scripts to the site. You can access it straight from SQL Monitor.

If you run applications that store data in SQL Server, you can use custom metrics to monitor and alert on the data they collect, so you can now use SQL Monitor to track business activity, too.

Get started with our custom metric walkthrough

Installing a metric and getting it working in SQL Monitor is easy, and we've provided a short walkthrough to guide you through the process. By the end of it, you'll have installed a custom metric that monitors whether specific backup jobs have been disabled. Read more…


Example metric

Table size (MB)

by the SQL Monitor Team

This metric is useful if you want to know exactly how much physical space a particular table is taking up, including the size of its indexes.

Read more or install this script from sqlmonitormetrics.red-gate.com