Redgate Hub

Product: Redgate Monitor

Multi-platform database observability for your entire estate.

All topics

All databases

All levels

Redgate Monitor logo

Monitoring Distributed SQL Servers using Redgate Monitor

If your SQL Server estate is large, or installed across different, isolated networks, or both, then you need a distributed monitoring solution. It is very easy to set up multiple base monitors in Redgate Monitor, and then to manage the monitoring, alerting and troubleshooting for your entire SQL Server estate,… Read more

Redgate Monitor logo

Custom Metrics for Detecting Problems with Ad-hoc Queries

Overuse of ad-hoc queries by applications is a common source of SQL Server performance problems. The symptoms include high CPU and memory pressure. Phil Factor offers a simple custom metric to monitor the percentage of ad-hoc queries being executed on a database, and shows how Redgate Monitor can detect when… Read more

Redgate Monitor logo

Using Redgate Monitor to Detect Problems on Databases that use Snapshot-based Transaction Isolation

Use of the read committed snapshot isolation level is often an effective way to alleviate blocking problems in SQL Server, without needing to rewrite the application. However, it can sometimes lead to tempdb contention. This article offers a small-scale solution (not suitable for use on large tables) to detect cases… Read more

Redgate Monitor logo

Monitoring and Troubleshooting Deadlocks with Redgate Monitor

This article explains what SQL Server deadlocks are, why they occur, why they require immediate investigation, and the diagnostic data required to troubleshoot them. It then demonstrates an "Update Order" deadlock condition and shows how to find the cause quickly, in Redgate Monitor, using the Extended Events deadlock graph provided… Read more

Redgate Monitor logo

Redgate's support for Azure SQL Database Managed Instances

Redgate Monitor logo

Investigating problems with ad-hoc queries using Redgate Monitor

Phil Factor demonstrates the performance problems that overuse of ad-hoc queries can cause and then how Redgate Monitor can warn us when they are the cause of these problems on your SQL Servers, using built-in metrics such as SQL Compilations/sec metric and Batch Requests/sec. Read more

Redgate Monitor logo

How to monitor the impact of patching on SQL Server performance

This article uses the Spectre/Meltdown bugs as means to demonstrate how you can use a tool like Redgate Monitor to assess the impact of patching on the throughput and performance of your SQL Servers. Read more

Redgate Monitor logo

How Redgate Monitor Monitors Azure-based SQL Server Failover Cluster Instances

Jon Hayman shows you how to set up Redgate Monitor to monitor Azure-based clustered SQL Server instances right alongside your on-premise clusters. Read more

Redgate Monitor logo

Alert Inbox Grouping Preview in Redgate Monitor

Redgate Monitor logo

Redgate Monitor Quick Tip: Using the SQL static code analysis performance rules

This quick tip illustrates Redgate Monitor's built-in set of Performance Rules for static code analysis. These rules are designed to highlight SQL syntax that could potential cause performance problems, and so indicate ways to improve the overall quality and performance of the workload, over time. Read more

Previous Next

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Hub

Product: Redgate Monitor

Monitoring Distributed SQL Servers using Redgate Monitor

Custom Metrics for Detecting Problems with Ad-hoc Queries

Using Redgate Monitor to Detect Problems on Databases that use Snapshot-based Transaction Isolation

Monitoring and Troubleshooting Deadlocks with Redgate Monitor

Redgate's support for Azure SQL Database Managed Instances

Investigating problems with ad-hoc queries using Redgate Monitor

How to monitor the impact of patching on SQL Server performance

How Redgate Monitor Monitors Azure-based SQL Server Failover Cluster Instances

Alert Inbox Grouping Preview in Redgate Monitor

Redgate Monitor Quick Tip: Using the SQL static code analysis performance rules

2026 State of the Database Landscape

Introduction to PostgreSQL for the data professional

Security and compliance

Database monitoring and observability

Database change management

Productivity and workflow automation

AI data readiness

Database modernization

Efficiency and cost optimization

Cloud migration and workload optimization

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Product: Redgate Monitor

Cookies on red-gate.com