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

Content with tag Monitoring Rss

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

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,374 reads

Monitoring SQL Server Agent job run times

Introduction A few months back, I was asked how long a particular nightly process took to run. It was a super...  Read more...
By Stefaans 2013/05/01 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,525 reads

Stairway to Transaction Log Management in SQL Server, Level 9: Monitoring the Transaction Log

Our major goal in terms of log maintenance for all databases under our care is to optimize for write performance, in order to support all activities that require SQL Server to write to the log, including data modifications, data loads, index rebuilds, and so on. However, it's also important to keep an eye on possible log fragmentation, which, as described previously, can affect the performance of processes that need to read the log, such as log backups and the crash recovery process.  Read more...
By Tony Davis 2013/04/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 5,385 reads

Custom Metrics for Monitoring Database Mirroring

SQL Monitor comes with plenty of metrics, but there are always going to be things that you want to measure that can't be done 'out of the box'. Taking database mirroring as an example, Grant shows that custom metrics can be used to monitor and alert whatever aspect of SQL Server or database that you need.  Read more...
By Additional Articles 2013/04/24 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,609 reads

dbWarden - A Free SQL Server Monitoring Package

dbWarden is a comprehensive monitoring and alerting solution for SQL Server 2005 or newer. It features an emailed Health Report and includes email and text notifications with customizable metrics for alerts such as Blocking, Long Running Queries and SQL Jobs, CPU %, Log file and TempDB growth.  Read more...
By Stevie Rounds, Michael Rounds 2013/04/12 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 16,626 reads

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,357 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,106 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

Find failed SQL Jobs

Simple T-SQL to find failed SQL Agent jobs  Read more...
By free mascot 2013/01/03 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 4,021 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 | 138 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,646 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,091 reads

Job Summary

This script lists the name, running and success status, last executed/currently executing step name, Average and Last duration, next run time and other related information about Jobs.  Read more...
By Adnan Korkmaz 2012/10/10 | Source: SQLServerCentral.com | Category: jobs
Rating: |  Discuss |   Briefcase | 1,889 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,128 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,091 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,091 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,091 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,782 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,435 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,923 reads
<< Newer    Items 21 to 40 of 190    Older >>
 
Tags
sql server 7 (55)    
administration (40)    
t-sql (14)    
performance tuning (11)    
sql server 2005 (10)    
miscellaneous (9)    
sql server 6.5 (7)    
configuring (6)    
jobs (6)    
powershell (6)    
auditing (5)    
advanced querying (4)    
backup / restore (4)    
dmv (4)    
replication (4)    
sql agent (4)    
asp.net (3)    
editorial (3)    
excel (3)    
indexing (3)    
integration services (ssis) (3)    
linked server (3)    
processes (3)    
programming (3)    
red gate software (3)    
scome (3)    
security (3)    
sql monitor (3)    
sql server 2008 (3)    
strategies (3)    
webinar (3)    
alerting (2)    
automation (2)    
blocking (2)    
blogs (2)    
cpu (2)    
database design (2)    
database size (2)    
default trace (2)    
disaster recovery (dr) (2)    
dts (2)    
dynamic management view (2)    
editorial - ipod (2)    
editorial - wmv (2)    
event logs (2)    
locking (2)    
naming standards (2)    
operations manager (2)    
performance monitoring (2)    
profiler (2)    
reporting services (ssrs) (2)    
reviews (2)    
schedulers (2)    
scom (2)    
sql trace (2)    
stored procedures (2)    
xml (2)    
activity (1)    
affinity (1)    
alerts (1)    
baselines (1)    
basics (1)    
capacity planning (1)    
change (1)    
change data capture (cdc) (1)    
clustering (1)    
code snippets (1)    
custom metrics (1)    
custom scripting (1)    
dac (1)    
data growth (1)    
database properties (1)    
database weekly (1)    
disk space (1)    
distributed queries (1)    
dynamic management views (1)    
editorial - mp3 (1)    
english query (1)    
enhancement (1)    
errorlogs (1)    
errors (1)    
extended events (1)    
failed logins (1)    
graphs (1)    
growth (1)    
hekaton (1)    
high availability (ha) (1)    
i/o (1)    
index details (1)    
information_schema.columns (1)    
information_schema.routine_columns (1)    
in-memory oltp (1)    
installation (1)    
instance properties (1)    
internals (1)    
ip (1)    
job (1)    
job activity (1)    
job history (1)    
mdw (1)    
metrics (1)    
missing indexes (1)    
on-call duties (1)    
openxml (1)    
oracle (1)    
orm (1)    
policy based management (pbm) (1)    
product reviews (1)    
production support (1)    
relational databases (1)    
server settings (1)    
server side trace (1)    
size (1)    
sp_spaceused (1)    
sp_who (1)    
sp_who2 (1)    
space (1)    
space usage (1)    
sql response (1)    
sql server 2012 (1)    
sql server 2014 (1)    
sql server error log (1)    
sql-dmo (1)    
sqlservercentral (1)    
stairway series (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)    
sys.objects (1)    
sys.syscomments (1)    
trace (1)    
transaction logs (1)    
transcation log (1)    
triggers (1)    
troubleshooting (1)    
updategrams (1)    
uptime (1)    
user defined function (udf) (1)    
what queries are running (1)    
xsl (1)