Redgate Hub

Topic: Performance monitoring and optimization

All products

All databases

All levels

Redgate Monitor logo

Tracking Queries in Redgate Monitor

Redgate Monitor logo

Top Query Search in Redgate Monitor

Redgate Monitor v12.0 has added a new Query Text Search feature to allow users to search the text of the most expensive queries that executed on a SQL Server instance over a period. Here's what it does, and how it works. Read more

Redgate Monitor logo

Is Tempdb Causing a Bottleneck?

One of your SQL Server instance shows a major dip in performance or throughput, affecting all the user databases. You notice that the slow interludes coincide, as if orchestrated. On investigation, it appears that several transactions running over that period were using a lot of space in tempdb. However, which… Read more

Redgate Monitor logo

When SQL Server Performance Goes Bad: Rogue Indexes

Phil Factor explains how Redgate Monitor helps focus performance tuning efforts on the tables and queries where 'rogue indexes' might be a significant problem, and then how to identify both 'missing' indexes that might be beneficial to the overall workload, and those that are unused or duplicated, and so are… Read more

Redgate Monitor logo

When SQL Server Performance Goes Bad: Implicit Conversions

In this article, you'll learn how to detect and remove a common cause of SQL Server query performance problems: reliance on implicit datatype conversions. We'll use a combination of plan cache queries, extended events, and Redgate Monitor. Read more

Redgate Monitor logo

Introduction to Analyzing Waits using Redgate Monitor

Phil Factor sets out with the modest aim of giving you enough of an introduction to waits to better understand the wait information you get from a SQL Server monitoring tool like Redgate Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events. Read more

Redgate Monitor logo

Automate Responses to Bad Deployments with Redgate Monitor

Jamie Wallis explains how Redgate Monitor can both reveal quickly who ran a deployment, and when, and automate the incident-response workflow to ensure it's dealt with swiftly. By extending such workflows to development and test servers, as well as production, the feedback cycle starts earlier, and you can stop problems… Read more

Redgate Monitor logo

When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation

Phil Factor on the fill factor, pages splits and index fragmentation, and how Redgate Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues. Read more

Redgate Monitor logo

Monitoring TempDB Contention using Extended Events and Redgate Monitor

When the tempdb database is heavily used, processes in any database on the instance will be forced to wait, due to contention as the SQL Server engine tries to manage allocation pages in tempdb. Phil Factor shows how to monitor for signs of trouble. Read more

Redgate Monitor logo

Tracking the number of active sessions on a database using Redgate Monitor

Phil Factor creates a simple custom metric to track the number of sessions that have recently done a read or write on a database. Having established a baseline for the metric, you'll be able to spot, and investigate the cause of, any wild deviations from normal behavior. 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 Test Data Manager

Redgate Hub

Topic: Performance monitoring and optimization

Tracking Queries in Redgate Monitor

Top Query Search in Redgate Monitor

Is Tempdb Causing a Bottleneck?

When SQL Server Performance Goes Bad: Rogue Indexes

When SQL Server Performance Goes Bad: Implicit Conversions

Introduction to Analyzing Waits using Redgate Monitor

Automate Responses to Bad Deployments with Redgate Monitor

When SQL Server Performance goes Bad: the Fill Factor and Excessive Fragmentation

Monitoring TempDB Contention using Extended Events and Redgate Monitor

Tracking the number of active sessions on a database using Redgate Monitor

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

Redgate Test Data Manager

Topic: Performance monitoring and optimization

Cookies on red-gate.com