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.

Find

  • 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

Use

  • 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

Share

Tempdb allocation contention

by
VN:RO [1.9.17_1161]

If your code uses temporary tables, variable tables or dynamic cursors, this metric can help identify whether you have contention on tempdb allocation. Read more

Number of unused indexes

by
VN:RO [1.9.17_1161]

Use this metric if you want to monitor the number of indexes per database that haven’t been used for the last month. Indexes that aren’t in use should be removed because they can degrade INSERT, UPDATE and DELETE performance, and they use storage space. Read more