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

Articles with tag Monitoring Rss

Search for any content tagged monitoring

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

Tracking Business Metrics

There can be more to managing a SQL Server instance than just examining the performance metrics. There are times when understanding how your system is performing for the application is important.  Read more...
By Steve Jones 2013/04/11 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 1,359 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,118 reads

DBA Hypochondria

It is easy to become overwhelmed by server symptoms (aka metrics), in the forlorn hope that the more we collect, the clearer a picture we'll assemble of what ails the server. We should, of course, be looking at the whole patient.  Read more...
By Tony Davis 2013/02/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 101 reads

Webinar: Forgotten Rings and Other Monitoring Stories

In this session, Grant Fritchey, Microsoft MVP, drills down into a few of the more obscure monitoring metrics that can give you very precise information about exactly what's happening within your server. He'll also show you how you can use custom metrics to enable these metrics in Red Gate's SQL Monitor.  Read more...
By Steve Jones, Grant Fritchey 2012/10/29 | Source: SQLServerCentral.com | Category: webinar
Rating: (not yet rated) |  Discuss |   Briefcase | 144 reads

How to Monitor for High CPU utilization in SQL Server

This is the method that Geoff Albin has used for years to monitor the CPU on his SQL Servers.  Read more...
By Geoff Albin 2012/10/19 (first published: 2010/11/17) | Source: SQLServerCentral.com | Category: cpu
Rating: |  Discuss |   Briefcase | 24,748 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,114 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,151 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,114 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,114 reads

SQLServerCentral Webinar Series #21 - Forgotten Rings & Other Monitoring Stories

Most common monitoring metrics are important and useful, especially over time, but they can fall short. How do you gather information to determine, for example, if you have buffer cache pressure? Register now for the free webinar. Wednesday, October 17 2012 4:00pm - 5:00pm BST  Read more...
By Press Release 2012/10/15 (first published: 2012/09/20) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 5,114 reads

Working with SQL Agent Durations

SQL Agent stores duration in HHMMSS format - not always useful. Discover how to use Powershell, some basic math, and T-SQL to tame these unruly values.  Read more...
By Kyle Neier 2012/08/23 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 2,786 reads

The Strategic Value of Monitoring SQL Servers

Why would you ever need to automatically monitor the SQL Servers in your care? What is the business value of doing so? What are the important features that a DBA should look for in a performance-monitoring tool? Rodney Landrum gives answers based on long experience.   Read more...
By Additional Articles 2012/06/19 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 3,447 reads

How to Receive Alerts When You Centralize Your SQL Server Event Logs

Learn how you can get alerts when you centralize the Event log. This is part 2 of the previous article "How to centralize your SQL Server Event Logs."  Read more...
By Geoff Albin 2014/05/09 (first published: 2012/05/24) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,962 reads

Perform Routine Server Checks Using PowerShell

Database administrators tend to perform a lot of routine checks, referred to as sanity checks, on a daily, weekly, and monthly basis. Rob Gravelle shows you how to write some PowerShell scripts to automate a couple of fairly common sanity checks.  Read more...
By Additional Articles 2012/05/21 | Source: Database Journal | Category: powershell
Rating:  Rate this |   Briefcase | 3,577 reads

SQLServerCentral Webinar #17: Monitoring your SQL Server Instances

Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.  Read more...
By Additional Articles 2012/04/11 (first published: 2012/04/05) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,021 reads

SQLServerCentral Webinar #17: Monitoring your SQL Server Instances

Join SQL Server MVP Brad McGehee to learn why it is so important to monitor your SQL Server instances and what you should consider when starting out. This webinar will also show you how you can use Red Gate's SQL Monitor for SQL Server monitoring and will include an overview of the new features released in v3.0, including the ability to create your own custom metric definition and to support different access permissions.  Read more...
By Additional Articles 2012/04/11 (first published: 2012/04/05) | Source: Red-Gate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 3,021 reads

Automating Daily Checks with Powershell

Using Powershell to create color coded backup reports for all servers in your environment.  Read more...
By Warren Campbell 2011/12/19 | Source: SQLServerCentral.com | Category: powershell
Rating: |  Discuss |   Briefcase | 10,617 reads

Create a Monitoring Server for SQL Server with PowerShell

At some point you are going to need a notification system for a range of events that occur in your servers. Laerte Junior shows how you can even set up temporary or permanent alerts for any WMI events to give you a system that fits your server environment perfectly.  Read more...
By Additional Articles 2011/11/09 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 2,808 reads

An Easy Way to Monitor SQL Server Replication

In SQL Server, replication is a widely adopted technology for the purpose of real-time data replication between SQL servers. It serves the purpose of keeping data consistent between multiple end points. So the last thing we want to hear from clients is that data is no longer in synch, and as DBA, we don't want to be the last person to realize replication is out of order or broken. Here are some steps you can take to monitor SQL Server replication.  Read more...
By Additional Articles 2011/10/26 | Source: Database Journal | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,816 reads

Disk Space Monitoring and Early Warning with PowerShell

Sean Duffy recently had an unwelcome encounter with Exchange Server Back Pressure, which cut off his message flow due to a lack of space on the server. To make sure it didn’t happen again, he found a way to automatically monitor all his servers from afar, with a little PowerShell magic.  Read more...
By Additional Articles 2011/09/12 | Source: SimpleTalk | Category: powershell
Rating:  Rate this |   Briefcase | 4,475 reads
<< Newer    Items 21 to 40 of 154    Older >>