SQLServerCentral.com Articles tagged SQL Monitor

Job overran Custom Metric

Fri, 10 May 2013 06:00:00 UT

This SQL Monitor custom metric tells you if a specific SQL Server Agent job that runs at the same time every day has overrun. The metric is useful when a job can have negative effects on other processes if it overruns.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

New Custom Metric: Long Running Job

Fri, 05 Apr 2013 06:00:00 UT

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.

How to write a custom metric

Tue, 15 Jan 2013 07:00:00 UT

You can extend SQL Monitor to track whatever you need to watch on your own system with custom metrics. Grant Fritchey shows us how.

SQLServerCentral Best Practices Clinic: Part 1

Tue, 25 Dec 2012 07:00:00 UT

We exposed the SQLServerCentral cluster for monitoring with SQL Monitor. Just like other companies, we have constraints on resources, and we have more work that needs to be done. Help us configure SQLServerCentral’s database servers with your suggestions on what is the highest priority for a website database back end.

SSC Clinic: Finding the rogue query

Thu, 13 Sep 2012 06:00:00 UT

When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.

Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor

Tue, 24 Jul 2012 06:00:00 UT

Wednesday July 25 2012, 6:00pm BST: Learn how you can use SQL Monitor to gather information and alert on extra performance data for your servers and applications, making this tool vital for keeping an eye on your business. In this free webinar David Bick, Product Manager at Red Gate, will give you an overview of SQL Monitor including the new custom metric functionality in v3.

Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor

Tue, 24 Jul 2012 06:00:00 UT

Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor

Tue, 24 Jul 2012 06:00:00 UT

Free Webinar: Monitoring your business, not just your servers – Getting the most out of SQL Monitor

Tue, 24 Jul 2012 06:00:00 UT

Red Gate Software’s SQL Monitor 3.0 gives users the power of custom metrics

Wed, 04 Apr 2012 06:00:00 UT

Red Gate Software has released Version 3.0 of SQL Monitor, a performance monitoring and alerting tool.

Learn more about the tools you used during the DBA in Space competition: SQL Monitor and SQL Source Control

Tue, 29 Nov 2011 07:00:00 UT

Join this webinar on Tuesday, Nov 29, 2011 to see how SQL Monitor and SQL Source Control can help you solve problems in your environment.

Learn more about the tools you used during the DBA in Space competition: SQL Monitor and SQL Source Control

Tue, 29 Nov 2011 07:00:00 UT

Join this webinar on Tuesday, Nov 29, 2011 to see how SQL Monitor and SQL Source Control can help you solve problems in your environment.

Learn more about the tools you used during the DBA in Space competition: SQL Monitor and SQL Source Control

Tue, 29 Nov 2011 07:00:00 UT

Join this webinar on Tuesday, Nov 29, 2011 to see how SQL Monitor and SQL Source Control can help you solve problems in your environment.

Using SQL Monitor in the Real World Webinar

Wed, 17 Aug 2011 06:00:00 UT

On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.

Using SQL Monitor in the Real World Webinar

Wed, 17 Aug 2011 06:00:00 UT

On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.

SQLServerCentral.com Best Practices Clinic: Part 5

Tue, 02 Aug 2011 06:00:00 UT

In this article, Brad McGehee takes a brief look at four resource intensive queries that are running on the SQL Server instance that runs the SQLServerCentral.com website. Don't miss out on the competition in this article.

Using SQL Monitor in the Real World Webinar

Wed, 17 Aug 2011 06:00:00 UT

On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.

SQLServerCentral Best Practices Clinic: Part 4

Mon, 06 Jun 2011 06:00:00 UT

In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.

Red Gate extends freedom of mobile SQL monitoring

Wed, 01 Jun 2011 06:00:00 UT

Red Gate has released SQL Monitor 2.3, providing improved data analysis and the ability to receive alerts through PagerDuty.

SQLServerCentral Best Practices Clinic: Part 3

Wed, 11 May 2011 06:00:00 UT

Part 3 of the analysis of the SQLServerCentral database cluster by MVP Brad McGehee. Follow along as he talks about some SQL Server settings and gives reasons why they should or should not be changed.

SQLServerCentral Best Practices Clinic: Part 2

Wed, 13 Apr 2011 06:00:00 UT

In part 2 of our best practices clinic, Brad McGehee looks at a couple of the items that were misconfigured on the SQLServerCentral database instances.

SQLServerCentral Best Practices Clinic: Part 1

Tue, 25 Dec 2012 07:00:00 UT

An In-Depth Examination of Red Gate SQL Monitor

Mon, 14 Feb 2011 07:00:00 UT

A review of SQL Monitor, the new DBA utility from Red Gate Software that can help you keep an eye on what your SQL Server instances are doing.

SQLServerCentral Webinar Series #6: Gathering and Interpreting Server Metrics including SQL Monitor

Tue, 14 Dec 2010 07:00:00 UT

In this webinar, MVP and noted author, Grant Fritchey shows you how to better keep track of what is happening on your instances by gathering information on performance from SQL Monitor and then using that to interpret the impact on your databases. Dec 14, 2010.

iPads for Christmas

Mon, 13 Dec 2010 07:00:00 UT

A contest from Red Gate and Steve Jones could get you a copy of SQL Monitor and an iPad for Christmas. Steve Jones talks about how you can enter, and perhaps win an iPad for yourself this holiday season.

SQLServerCentral Webinar Series #6: Gathering and Interpreting Server Metrics including SQL Monitor

Tue, 14 Dec 2010 07:00:00 UT

Put Your Thinking Caps On

Fri, 10 Dec 2010 07:00:00 UT

Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.

What's Happening Here?

Thu, 09 Dec 2010 07:00:00 UT

A look at what's happening with the SQLServerCentral servers based on the public information exposed by SQL Monitor.

Put Your Thinking Caps On

Fri, 10 Dec 2010 07:00:00 UT

Three contests from Red Gate Software are coming next week. Get a hint about what might be coming and set a reminder on your calendar.

SQLServerCentral Webinar Series #6: Gathering and Interpreting Server Metrics including SQL Monitor

Tue, 14 Dec 2010 07:00:00 UT