New Custom Metric: Long Running Job

SQL Monitor’s Job duration unusual alert is a powerful tool for keeping track of most jobs in your SQL Server environment. It works by comparing the running time of any job instance against the median for that job, and identifying when a variation in the job duration could hint at a performance problem. However, if your environment contains big jobs whose durations vary by several orders of magnitudes, it can be tricky to specify what kind of variation is expected and what would be unusual. For these cases, it is possible to go beyond the functionality of the built-in alert with a custom metric.

Red Gate’s new custom metrics site - with a little help from our friends

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.

Database Development Tasks Survey

We'd like to better understand the kinds of database related development tasks that you perform, so that we can ensure our tools are helping you to be more productive.

Webinar: Whatever your source control system - seamlessly link it to SQL Server

In this webinar consisting of 30 minutes of software demonstrations followed by Q&A, you will learn how to link your database to your existing source control system within SQL Server Management Studio using Red Gate’s SQL Source Control.

We will also give you an exclusive preview of forthcoming custom scripts features in the next version of SQL Source Control and SQL Compare.

Meet the Red Gate Team this month

Find out where you can meet the Red Gate team in the US, ask a question, get a custom demo, and maybe a prize as well.