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

Content with tag Monitoring Rss

   Items 1 to 20 of 183    Older >>
 

Mini-Me

This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.  Read more...
By Steve Jones 2014/03/07 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 542 reads

SQL Monitor Metric: Processes in a runnable state (scheduler query)

Use this script in SQL Monitor to determine the general load on the operating system you can get a count of the processes that are in a runnable state. This value will go up and down as various systems run on the operating system. It’s only a measure of load on the system and won’t indicate the cause of problems, but will show you pressure on the system.   Read more...
By Press Release 2013/12/03 | Source: SQL Monitor Metrics | Category: monitoring
Rating:  Rate this |   Briefcase | 2,848 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,692 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2013/09/19 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 7,742 reads

Automate SQL Server Log Monitoring

Let SQL do the work and monitor your SQL Error Log files.  Read more...
By Willem Gossink 2013/09/16 | Source: SQLServerCentral.com | Category: sql server error log
Rating: |  Discuss |   Briefcase | 6,879 reads

Monitoring job history using Reporting Services

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.  Read more...
By Tomaz Kastrun 2013/09/05 | Source: SQLServerCentral.com | Category: job
Rating: |  Discuss |   Briefcase | 6,741 reads

Eight Steps to Effective SQL Server Monitoring

If you need to start monitoring your SQL Server instances and database, and there are many good reasons to do so, Tony Davis gives you the eight essential steps to diagnosing problems quickly.  Read more...
By Additional Articles 2013/08/26 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 4,432 reads

Windows Failover Cluster Monitor

Windows Failover Clusters are fantastic, they provide High Availability for mission critical SQL Server instances and make my life as...  Read more...
By Chris McGowan 2013/08/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,061 reads

SQL Server System Report

Report to keep you abreast of various details of an instance, including: general properties and settings, uptime, drive space, DB size allocation, growth stats, backups, jobs, index fragmentation, missing and unused indexes, and much more...  Read more...
By Sean Smith 2013/10/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,692 reads

Baselining with SQL Server Dynamic Management Views

When you're monitoring SQL Server, it's better to capture a baseline for those aspects that you're checking, such as workload, Physical I/O or performance. Once you know what is normal, then performance tuning and resource provisioning can be done in a timely manner before any problems becomes apparent. We can prevent problems by being able to predict them. Louis shows how to get started.  Read more...
By Additional Articles 2013/07/30 | Source: SimpleTalk | Category: baselines
Rating:  Rate this |   Briefcase | 3,665 reads

Disaster Recovery Tip #6 - Monitor Your Systems

Today's complex systems are too large to be able to rely on any DBA's memory for knowledge of each component, and its configuration options and settings.   Read more...
By Press Release 2013/07/25 | Source: SQLServerCentral.com | Category: disaster recovery (dr)
Rating: (not yet rated)  Rate this |   Briefcase | 3,477 reads

The Ten Commandments of SQL Server Monitoring

It is easy to get database monitoring wrong. There are several common-sense rules that can make all the difference between a monitoring system that works for you and helps to avoid database problems, and one that just creates a distraction. Adam Machanic spells out the rules, based on his considerable experience with database monitoring.  Read more...
By Additional Articles 2013/05/13 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 7,591 reads

Another way to track the database data growth

Scripts will display size of the data in the database/data files and remaining allocated space.  Read more...
By Max Yasnytsky 2013/05/10 | Source: SQLServerCentral.com | Category: database size
Rating: |  Discuss |   Briefcase | 3,341 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,292 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,103 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,201 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,562 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,095 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,348 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,051 reads
   Items 1 to 20 of 183    Older >>
 
Tags
sql server 7 (55)    
administration (39)    
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)    
replication (4)    
sql agent (4)    
asp.net (3)    
editorial (3)    
excel (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)    
dmv (2)    
dts (2)    
editorial - ipod (2)    
editorial - wmv (2)    
event logs (2)    
indexing (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)    
editorial - mp3 (1)    
english query (1)    
enhancement (1)    
errorlogs (1)    
errors (1)    
extended events (1)    
failed logins (1)    
graphs (1)    
growth (1)    
high availability (ha) (1)    
i/o (1)    
index details (1)    
information_schema.columns (1)    
information_schema.routine_columns (1)    
installation (1)    
instance properties (1)    
internals (1)    
ip (1)    
job (1)    
job activity (1)    
job history (1)    
mdw (1)    
metrics (1)    
on-call duties (1)    
openxml (1)    
oracle (1)    
orm (1)    
policy based management (pbm) (1)    
product reviews (1)    
production support (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 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)