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 195    Older >>
 

Monitor Database Growth and Usage

Create a repository of all your database devices and stay informed about changes in their size and usage.  Read more...
By Willem Gossink 2014/12/04 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 6,214 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,504 reads

The 3AM Meltdown - New DBA Team Article

Where do you start fixing a SQL Server crash when there isn’t a single clue? The DBA Team had better find out quick, or they’re not going to get any sleep tonight. Find out how it all goes.  Read more...
By Additional Articles 2014/10/16 | Source: Red-Gate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 8,428 reads

Monitoring Longest Running Transaction using SQL Server Agent Alerts

Step by Step guide to setup SQL Server Agent Alert for the proactive monitoring of Monitoring of Longest Running Transactions.  Read more...
Rating: |  Discuss |   Briefcase | 6,060 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,855 reads

The Road To Hell - new article from the DBA Team

Joe Celko & Chris Date guest as the sinister Relational Police in this new DBA Team adventure. Can the DBA Team save another doomed database? Find out.  Read more...
By Additional Articles 2014/08/07 | Source: Red-Gate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 10,407 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,504 reads

Dynamic Management Views: Changes in SQL Server 2014

SQL Server 2014 has a number of new DMVs, and some changes from SQL Server 2012. What are the new views and changes, and how can be useful to you?  Read more...
By Edward Pollack 2014/07/08 | Source: SQLServerCentral.com | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 3,950 reads

Dynamic Management Views: Changes in SQL Server 2012

There were many new DMVs added in SQL Server 2012, and some that have changed since SQL Server 2008 R2. This is a brief overview of the biggest changes and what they mean to you!  Read more...
By Edward Pollack 2014/07/03 | Source: SQLServerCentral.com | Category: dynamic management view
Rating: |  Discuss |   Briefcase | 5,104 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,989 reads

Index Utilization Trending

An important part of regular database maintenance is to monitor index usage and make adjustments as needed. How can we monitor, store, and trend this data effectively over time?  Read more...
By Edward Pollack 2014/05/05 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,347 reads

How to centralize your SQL Server Event Logs

Learn how you can centralize the Event log data for your servers using a process that Geoff Albin has been using for over 10 years.  Read more...
By Geoff Albin 2014/05/02 (first published: 2010/11/08) | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 11,783 reads

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 | 562 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 | 3,068 reads

SQL Server System Report

Overview report for tracking key database performance metrics, general system stats, overall activity, and general server info, including: 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 2014/09/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 11,855 reads

usp_who5

Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2014/11/03 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 9,504 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 | 7,295 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 | 7,112 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,665 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,479 reads
   Items 1 to 20 of 195    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 (1)    
database device size (1)    
database device usage (1)    
database weekly (1)    
details (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)    
indexes (1)    
information_schema.columns (1)    
information_schema.routine_columns (1)    
in-memory oltp (1)    
installation (1)    
instance (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)    
properties (1)    
relational databases (1)    
server (1)    
server side trace (1)    
settings (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 agent alerts (1)    
sql server error log (1)    
sql-dmo (1)    
sqlservercentral (1)    
stairway series (1)    
summary (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)    
transactions (1)    
transcation log (1)    
trends (1)    
triggers (1)    
troubleshooting (1)    
updategrams (1)    
uptime (1)    
user defined function (udf) (1)    
what queries are running (1)    
xsl (1)