Creating a custom metric

Collect the performance data you care about in Redgate's SQL Monitor using custom metrics

Custom metrics are T-SQL scripts you can add to SQL Monitor to record extra kinds of data.

You can analyze and receive alerts about your custom data just like everything else SQL Monitor collects.

This library contains free, tried and tested custom metrics you can install straightaway, and resources to help you write your own.

Find custom metrics

SQL Monitor

SQL Monitor is a SQL server monitoring tool that gives you real-time SQL Server performance data with alerts and diagnostics.

With its embedded expertise from SQL Server experts and MVPs, it gives you the information and advice you need to find and fix issues before users are even aware.

Find out more about SQL Monitor

Maximize SQL Server monitoring with custom metrics

SQL Monitor is a performance monitoring and alerting tool for SQL Server, with a web-based UI. Its custom metrics feature lets you run T-SQL queries against SQL Servers to collect specific data. But what if you don’t want to write your own queries? No problem. Red Gate has brought together a range of quality custom metrics for you to use in SQL Monitor.


  • Browse popular metric categories or search for keywords or authors
  • Discover new and useful ways to monitor your SQL Servers
  • Decide quickly which metrics will broaden your monitoring range


  • Automatically install a metric in your version of SQL Monitor
  • Tune settings specific to your environment by following our guidelines
  • Start collecting, analyzing and alerting on data right away


Table size (MB)

VN:RO [1.9.17_1161]

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

Memory used by ad hoc queries running once

VN:RO [1.9.17_1161]

This metric measures the amount of memory used by the total number of ad hoc queries in the plan cache that have only run one time. Read more