Redgate Hub

Topic: Performance monitoring and optimization

All products

All databases

All levels

Redgate Monitor logo

Monitoring SQL Server Performance: What's Required?

A monitoring tool must provide us with an understanding of the often-complex performance patterns that databases exhibit when under load, so that we can predict how they will cope with expansion or increase in scale. It must also helps us spot the symptoms of stress and act before they become… Read more

Redgate Monitor logo

Monitoring the Application with Redgate Monitor: Website Activity

Using a PowerShell script that collects log data from a web server, plus a Redgate Monitor custom metric, Phil Factor offers a way to check for suspicious website errors and unusual patterns of activity, right alongside your database monitoring. Read more

Redgate Monitor logo

Monitoring Azure SQL Database with Redgate Monitor

Grant Fritchey explains the Azure-tailored metrics and alerts that you need to diagnose performance problems with your Azure SQL Databases, and let you know which resource (CPU, data IO or log IO) is the bottleneck. Read more

Redgate Monitor logo

Why is my SQL Server Query Suddenly Slow?

A SQL Server query is suddenly running slowly, for no obvious reason. Grant Fritchey shares a 5-point plan to help you track down the cause and fix the problem. Read more

Redgate Monitor logo

The Changing Role of SQL Server Monitoring

Grant Fritchey explains how a modern monitoring tool must adapt, as our SQL Server databases grow in number and size, and migrate onto new cloud-based, containerized or virtual machine-based SQL Servers. Read more

Redgate Monitor logo

Troubleshooting Blocking in SQL Server using Redgate Monitor

Redgate Monitor tells us immediately when significant blocking occurs, and where, during busy periods, and provides the full blocking chain, in an easy-to-digest graphical format, so we can diagnose and resolve the blocking quickly. 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

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

Previous Next

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Redgate Hub

Topic: Performance monitoring and optimization

Monitoring SQL Server Performance: What's Required?

Monitoring the Application with Redgate Monitor: Website Activity

Monitoring Azure SQL Database with Redgate Monitor

Why is my SQL Server Query Suddenly Slow?

The Changing Role of SQL Server Monitoring

Troubleshooting Blocking in SQL Server 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

Investigating problems with ad-hoc queries using Redgate Monitor

2025 Stand der Datenbank-Landschaft

Einführung in PostgreSQL für den Datenprofi

Sicherheit und Compliance

Datenbankmonitoring und Observability

Datenbankänderungsmanagement

Produktivität und Workflow-Automatisierung

KI-bereite Daten

Datenbankmodernisierung

Effizienz und Kostenoptimierung

Cloud-Migration und Workload-Optimierung

Redgate Flyway

Redgate Monitor

SQL Toolbelt Essentials

Redgate Test Data Manager

Topic: Performance monitoring and optimization

Cookies on red-gate.com