Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag SQL Monitor Rss

Search for any content tagged sql monitor

<< Newer    Items 21 to 40 of 61    Older >>
 

New SQL Monitor Custom Metric: Failed SQL Server logins

This metric returns the number of ‘login failed’ error messages found in the SQL Server error log file in the last hour.  Read more...
By Press Release 2013/08/02 | Source: Red-Gate | Category: red gate
Rating: (not yet rated)  Rate this |   Briefcase | 3,418 reads

SQL Monitor Custom Metric: Top Buffer Cache Object

This metric measures the amount of memory used in the buffer cache by the largest object (based on the number of pages). It checks the sys.dm_os_buffer_descriptors to identify the object, and returns the relative percentage used. You should use this metric if you want to monitor what is in the buffer area, or if you are having performance-related disk read problems.  Read more...
By Press Release 2013/07/22 | Source: Red-Gate | Category: top buffer cache object
Rating: (not yet rated)  Rate this |   Briefcase | 3,115 reads

New SQL Monitor Custom Metric: Untrusted Check Constraints

This metric returns the number of check constraints that have their is_not_trusted flag set to 1 in the sys.check_constraints table. Untrusted constraints force SQL Server to construct less efficient query plans, because it doesn’t know enough about the kind of data contained in the table. This can point to a data integrity issue which should be investigated.  Read more...
By Press Release 2013/07/08 | Source: Red-Gate | Category: sql monitor
Rating:  Rate this |   Briefcase | 2,361 reads

New SQL Monitor Custom Metric: Database Autogrowth

This metric for Red Gate SQL Monitor measures the number of database autogrowth events (data file or log file) in the last hour. Too many autogrowth events causes disk fragmentation which requires a change in the autogrowth settings of a database.  Read more...
By Press Release 2013/06/25 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,743 reads

New Custom Metric: Percentage of blocked connections

This metric reports the number of connections that are currently blocked, divided by the total count of current connections. Most well-balanced SQL Servers will have some degree of blocking. This metric attempts to measure the impact of lead blocking queries against other queries. Higher values indicate that many connections are being blocked, and queries should be tuned to reduce the amount of contention.  Read more...
By Press Release 2013/06/07 | Source: SQLServerCentral.com | Category: blocking
Rating: (not yet rated)  Rate this |   Briefcase | 2,814 reads

New SQL Monitor Custom Metric: Issues found by sp_Blitz

This custom metric adds Brent Ozar's popular SP_Blitz scripts to Red Gate SQL Monitor. It looks for configuration, security, health and performance problems, and reports back with a list of issues for you to look into. It’s great for quickly understanding the state of a server you've been asked to look after.  Read more...
By Press Release 2013/05/29 | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 3,094 reads

Job overran Custom Metric

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.  Read more...
By Press Release 2013/05/10 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,391 reads

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.  Read more...
By Press Release 2013/04/05 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated)  Rate this |   Briefcase | 2,120 reads

How to write a custom metric

You can extend SQL Monitor to track whatever you need to watch on your own system with custom metrics. Grant Fritchey shows us how.  Read more...
By Grant Fritchey 2013/01/15 | Source: SQLServerCentral.com | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 2,341 reads

SQLServerCentral Best Practices Clinic: Part 1

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.  Read more...
By Brad McGehee 2012/12/25 (first published: 2011/03/07) | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 22,610 reads

SSC Clinic: Finding the rogue query

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.  Read more...
By Grant Fritchey 2012/09/13 | Source: SQLServerCentral.com | Category: memory
Rating: |  Discuss |   Briefcase | 5,844 reads

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

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.  Read more...
By Press Release 2012/07/24 (first published: 2012/07/06) | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,621 reads

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

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.  Read more...
By Press Release 2012/07/24 (first published: 2012/07/06) | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,621 reads

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

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.  Read more...
By Press Release 2012/07/24 (first published: 2012/07/06) | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,621 reads

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

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.  Read more...
By Press Release 2012/07/24 (first published: 2012/07/06) | Source: Red-Gate | Category: sql monitor
Rating: (not yet rated)  Rate this |   Briefcase | 4,621 reads

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

Red Gate Software has released Version 3.0 of SQL Monitor, a performance monitoring and alerting tool.  Read more...
By Press Release 2012/04/04 | Source: Red-Gate | Category: red gate software
Rating: (not yet rated) |  Discuss |   Briefcase | 957 reads

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

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.  Read more...
By Press Release 2011/11/29 (first published: 2011/11/21) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 1,165 reads

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

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.  Read more...
By Press Release 2011/11/29 (first published: 2011/11/21) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 1,165 reads

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

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.  Read more...
By Press Release 2011/11/29 (first published: 2011/11/21) | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 1,165 reads

Using SQL Monitor in the Real World Webinar

On Tuesday August 23rd, Brad McGehee will take you through real-world examples to show what Red Gate SQL Monitor can do for you.  Read more...
By Press Release 2011/08/17 (first published: 2011/07/20) | Category: sql monitor
Rating: (not yet rated) |  Discuss |   Briefcase | 1,705 reads
<< Newer    Items 21 to 40 of 61    Older >>