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

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 | 100 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 | 3,871 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 | 131 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,348 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,041 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,841 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,046 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,041 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,041 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,041 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,765 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,417 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 2012/05/24 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 4,205 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,535 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 | 2,997 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 | 2,997 reads

sp_spaceused2

The sp_spaceused procedure does not provide schema name in return. Here is sp_spaceused2 that does.  Read more...
By Jason S Wong 2012/04/02 | Source: SQLServerCentral.com | Category: size
Rating: |  Discuss |   Briefcase | 1,359 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 911 reads

Who did what?

This select will show the last sql statement for every open session plus many helpfull information.  Read more...
By mobasha B 2012/01/13 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,864 reads

Monitor Any Linked Server From SQL 2005

Best way to monitor Excel, Access, SQL Linked Servers from SQL 2005  Read more...
By Sakthivel Chidambaram 2011/12/19 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 3,018 reads
<< Newer    Items 21 to 40 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)