SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Monitoring Rss

   Items 1 to 20 of 225    Older >>

Making the database key to DevOps with comprehensive, customizable monitoring

The speed of business today demands that the development and deployment of applications is fast-moving, with frequent yet error-free releases. That’s why the adoption of DevOps is trickling down from Amazon, Facebook, Google and the other usual suspects to every company that relies on technology to drive its communications or sales with users.  Read more...
By 2018/07/19 | Source: Redgate | Category: devops
Rating: (not yet rated)  Rate this |   Briefcase | 1,520 reads

Be Prepared with Baselines

Analyzing performance often requires you to understand what is normal and what is not. Steve talks about the importance of baselines.  Read more...
By Steve Jones 2018/06/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 48 reads

Database-based Transaction Counting Find Script

Database-based Transaction Counting Find Script 
By Yusuf Kahveci 2018/06/08 | Source: SQLServerCentral.com | Category: monitoring
Rating: |  Discuss |   Briefcase | 2,381 reads

The State of SQL Server Monitoring 2018

Over 600 technology professionals who work in organizations that use SQL Server recently responded to our survey to discover the current state of SQL Server monitoring.  Read more...
By 2018/05/21 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 1,474 reads

Detecting Problems on Databases that use Snapshot-based Transaction Isolation

If you’re using SQL Server’s Read Committed Snapshot Isolation level (RCSI) to avoid long waits for a blocked resource, then you’ll want to monitor for possible side effects. This article describes one way to monitor for such problems, using an alert on version_ghost_record_count, to warn us when the number of row versions in tempdb is getting very high.  Read more...
By 2018/04/26 | Source: Redgate | Category: read committed snapshot isolation
Rating: (not yet rated)  Rate this |   Briefcase | 2,347 reads

Custom Metrics for Detecting Problems with Ad-hoc Queries

A common SQL Server crime is the unnecessary overuse of ad-hoc queries by applications. In this article, Phil Factor shares some custom queries for monitoring problems that can be caused by this.  Read more...
By 2018/04/23 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 2,754 reads

Monitor Query Performance Using Query Store in SQL Server

The Query Store captures a history of queries, execution plans, and runtime statistics, which persist within SQL Server and can be reviewed later.  Read more...
By Additional Articles 2018/04/12 | Source: Database Journal | Category: query performance
Rating:  Rate this |   Briefcase | 4,011 reads

Monitoring and Troubleshooting Deadlocks with SQL Monitor

This article will discuss why deadlocks occur, why they require immediate investigation by the DBA, and the diagnostic data required to troubleshoot them.  Read more...
By 2018/03/26 | Source: Redgate | Category: deadlocks
Rating: (not yet rated)  Rate this |   Briefcase | 3,694 reads

Custom Replication Status Record Latency Monitor

Monitors replicated tables for any publisher/subscriber for latency in record counts, alerts via email if latency exists beyond a specified threshold  Read more...
By MyDoggieJessie 2018/02/27 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 151 reads

How to monitor the impact of patching on SQL Server performance

In this article, Redgate use the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like SQL Monitor to assess the impact of patching on your SQL Server estate.  Read more...
By 2018/02/13 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 3,292 reads

Building a Custom Blocked Process Report

Blocking in SQL Server is normal behavior, but excessive blocking can lead to many complaints and is a symptom of poor performance. SQL Server contains a vast amount of information that can help when troubleshooting performance issues like blocking, but understanding and gathering that information when you need it is a lot of work. Darko Martinovic explains his solution for a custom blocking report.  Read more...
By Additional Articles 2018/02/06 | Source: SimpleTalk | Category: monitoring
Rating:  Rate this |   Briefcase | 3,445 reads

Free webinar: Change your SQL Server troubleshooting from reactive to proactive with a monitoring tool

Redgate’s James King and Ben Emmett will demonstrate how to troubleshoot your SQL Server estate, and discuss how it shouldn’t be about reacting to problems when they occur, but rather having the tools to make proactive decisions to plan ahead, identify potential disruptions, fix common problems and make improvements.   Read more...
By 2018/02/01 | Source: Redgate | Category: redgate
Rating: (not yet rated)  Rate this |   Briefcase | 8,616 reads


Enhanced version of Microsoft's sp_who / sp_who2 system stored procedures.  Read more...
By Sean Smith 2018/01/23 | Source: SQLServerCentral.com | Category: sp_who
Rating: |  Discuss |   Briefcase | 12,663 reads

How to manage and monitor large SQL Server estates

Managing a couple of SQL Servers is a whole different ball game compared to managing 10’s or 100’s of servers. With so much available data to take in, this webinar will guide you through what’s important and what’s noise.  Read more...
By 2017/11/27 | Source: Redgate | Category: webinar
Rating: (not yet rated)  Rate this |   Briefcase | 7,042 reads

VMware monitoring in SQL Monitor

The Redgate SQL Monitor team has been looking into how you can more effectively monitor SQL Server running on a virtual machine, and are pleased to announce that they've begun this by introducing support for VMware in SQL Monitor version 7.0.11. Find out more about the beta feature in this blog post.  Read more...
By 2017/06/09 | Source: Redgate | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 3,503 reads

Five Useful SQL Server Management Practices

This article outlines five SQL Server capabilities you can use to enhance your efficiency as a DBA.  Read more...
By Kenneth Igiri 2017/01/18 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 3,006 reads

What is the Future of Monitoring?

Monitoring your systems is critical to ensuring security and stability. Steve Jones shares a few thoughts on where monitoring might go with more computer assistance in the future.  Read more...
By Steve Jones 2016/09/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 69 reads

5 Monitoring Queries for SQL Server

Every DBA squirrels away favourite queries for monitoring SQL Server. Nowadays many of these are too complex to keep in your head. Dennes describes how he uses T-SQL queries for solving problems, whether it involves fixing the problems of missing indexes, preventing unrestrained autogrowth, avoiding index fragmentation, checking whether jobs have failed or avoiding memory stress conditions.  Read more...
By Additional Articles 2016/07/08 | Source: SimpleTalk | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 9,906 reads

Monitoring and Alerting

Knowing what is happening on your systems, and being told when a system is not behaving normally is very important for administrators. Steve Jones has a few thoughts on monitoring today.  Read more...
By Steve Jones 2016/06/30 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 118 reads

Move an Existing Log Shipping Database to a New Monitor Server

How to move a log shipping database to a new monitor server without removing and rebuilding the log shipping setup.  Read more...
By Dane Boulton 2016/04/04 | Source: SQLServerCentral.com | Category: log shipping
Rating: |  Discuss |   Briefcase | 953 reads
   Items 1 to 20 of 225    Older >>
sql server 7 (55)    
administration (42)    
t-sql (14)    
performance tuning (11)    
sql monitor (11)    
sql server 2005 (10)    
miscellaneous (9)    
editorial (8)    
agent jobs (7)    
redgate (7)    
sql server 6.5 (7)    
configuring (6)    
powershell (6)    
replication (6)    
auditing (5)    
webinar (5)    
advanced querying (4)    
backup and restore (4)    
dmv (4)    
indexing (4)    
security (4)    
sql agent (4)    
alerting (3)    
asp.net (3)    
custom metrics (3)    
excel (3)    
integration services (ssis) (3)    
linked server (3)    
processes (3)    
programming (3)    
redgate software (3)    
scome (3)    
sql server 2008 (3)    
strategies (3)    
troubleshooting (3)    
alerts (2)    
automation (2)    
blocking (2)    
blogs (2)    
clustering (2)    
cpu (2)    
database design (2)    
database size (2)    
database weekly (2)    
default trace (2)    
disaster recovery (dr) (2)    
dts (2)    
dynamic management view (2)    
editorial - ipod (2)    
editorial - wmv (2)    
error log (2)    
event logs (2)    
locking (2)    
metrics (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)    
sqlservercentral (2)    
stored procedures (2)    
transaction log (2)    
xml (2)    
activity (1)    
ad hoc queries (1)    
affinity (1)    
backup and recovery (1)    
baselines (1)    
basics (1)    
blocked process report (1)    
blocked processes (1)    
capacity planning (1)    
change (1)    
change data capture (cdc) (1)    
code snippets (1)    
custom scripting (1)    
dac (1)    
data growth (1)    
database (1)    
database device size (1)    
database device usage (1)    
deadlocking (1)    
deadlocks (1)    
deployment (1)    
details (1)    
devops (1)    
disk space (1)    
distributed queries (1)    
dynamic management views (1)    
editorial - mp3 (1)    
english query (1)    
enhancement (1)    
error handling (1)    
extended events (xe) (1)    
failed logins (1)    
friday poll (1)    
graphs (1)    
growth (1)    
hekaton (1)    
high availability (ha) (1)    
i/o (1)    
information_schema.columns (1)    
information_schema.routine_columns (1)    
in-memory oltp (1)    
installation (1)    
instance (1)    
internals (1)    
ip (1)    
job activity (1)    
job history (1)    
log shipping (1)    
mdw (1)    
missing indexes (1)    
on-call duties (1)    
openxml (1)    
oracle (1)    
orm (1)    
patching (1)    
performance (1)    
policy based management (pbm) (1)    
product reviews (1)    
production support (1)    
properties (1)    
query performance (1)    
query store (1)    
read committed snapshot isolation (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 (1)    
sql-dmo (1)    
stairway series (1)    
summary (1)    
survey (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 count (1)    
transactions (1)    
trends (1)    
triggers (1)    
updategrams (1)    
uptime (1)    
user defined function (udf) (1)    
vmware (1)    
wait for delay (1)    
what queries are running (1)    
xsl (1)