With contributions from MVPs and the SQL Server community, the SQL Monitor team at Red Gate has put together a custom metrics site, SQL Monitor Metrics, to accompany the release of SQL Monitor 3.2. The site hosts T-SQL scripts which can be imported directly to SQL Monitor for custom metric monitoring.
SQL Monitor Metrics is an online resource for custom metrics, where people can share their metrics with the community, review those others have shared, and use these scripts with their copy of SQL Monitor. With custom metrics SQL Monitor can monitor and alert on any data stored in a SQL Server database so you can track metrics important to your business.
You can import metrics directly from the website and configure them in SQL Monitor for your environment. To get you started, we have a couple of detailed guidance articles explaining how to set up new custom metrics in SQL Monitor and how to write a custom metric.
The SQL Monitor team reached out to SQL Server MVPs and the wider SQL Server community to submit the first T-SQL scripts to the site, so there are a couple of people we’d like to thank for helping us get this project off the ground: Fabiano Amorim (@mcflyamorim), Jonathan Allen (@FatherJack), Louis Davidson (@drsql), Stuart Ainsworth (@codegumbo), and TJay Belt (@tjaybelt). While we’re saying Thank You, Brad McGehee (@bradmcgehee) and Grant Fritchey (@GFritchey) were indispensable as always.
We hope that you’ll take a moment and explore the site - the more people who contribute to it the better the site will be for everyone so we encourage you to get involved. Custom metrics are enabled in SQL Monitor version 3.0 and later; you can download a 14 day free trial of SQL Monitor 3.2, or if you have an older version of SQL Monitor, find out how to upgrade.