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

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 of them, if any, are causing the tempdb bottleneck, and why? Read more

Ten Reasons your SQL Server Monitoring will Scale

This article explains ten ways that SQL Monitor tackles the problem of scaling out the coverage of a single, lightweight monitoring system, and so allows your teams to maintain the health and performance of larger collections of databases and higher numbers of monitored SQL servers. Read more

Tackling the Challenges of Hybrid, Cloud, and On-Premises SQL Server Estates

More and more organizations are managing some part of their data in the cloud. Gartner and similar organizations are showing massive growth in cloud adoption in 2020. Redgate’s own State of Database Monitoring survey shows cloud adoption rising rapidly. Everyone, it seems, is moving to the cloud. Yet, there is data out there that’s not Read more

Improving SQL Monitor’s Database Performance

Jeremiah Peschka, a tech lead for SQL Monitor development, explains the new SQL Server configuration options available for the data repository, and how enabling them might improve SQL Monitor performance, when reading and writing monitoring data. Read more

When SQL Server Performance Goes Bad: Rogue Indexes

Phil Factor explains how SQL 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 doing more harm than good. Read more

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 SQL Monitor. Read more

Introduction to Analyzing Waits using SQL 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 SQL Monitor, and the rather overwhelming amount of information available in the underlying DMVs and Extended Events. Read more

Automate Responses to Bad Deployments with SQL Monitor

Jamie Wallis explains how SQL 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 from ever reaching the users. Read more

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 SQL Monitor can help you decide if a custom fill factor for certain indexes might help alleviate performance issues. Read more

OVERVIEW

BY NEED

BY ROLE

BY INDUSTRY

Product articles
SQL Monitor
SQL Server Performance Monitoring