October 2026

SQL Server Memory Usage: Where Did All the RAM Go?

Task Manager says SQL Server ate all the RAM. Here is how to read SQL Server memory usage as three nested layers and find the… Read More »SQL Server Memory Usage: Where Did All the RAM Go?

Is a SQL Server query slow when busy because of its plan or because of its neighbors? Compare quiet and busy Query Store intervals to… Read More »SQL Server Query Slow When Busy? Find Out Which Kind

Database Health Monitor Version 4 Instance Reports Stedman SQL Podcast Sn 3 Ep 17 In Season 3, Episode 17 of the Stedman SQL Server Podcast,… Read More »Database Health Monitor Version 4 Instance Reports Stedman SQL Podcast Sn 3 Ep 17

A deadlock heat map shows which hour and day your SQL Server deadlocks cluster, so you can find the colliding job instead of guessing from… Read More »Deadlock Heat Map: Find the Hour Your Deadlocks Hit

Query Store stopped collecting, and nothing told you. Here is how to prove whether the history behind your tuning reports is really there, and fix… Read More »Query Store Stopped Collecting? How to Tell Fast

SQL Server backup status is more than a last backup date. See how exposure, log chains and the restore sequence show what you would really… Read More »SQL Server Backup Status: Beyond the Last Backup Date

Query Store plan instability hides behind plans that cost the same. Here is how to measure how long a plan lasts and which queries keep… Read More »Query Store Plan Instability: Why It Was Fast Yesterday

Which hour of the day is slower than it used to be? Sort Query Store history by hour and read each hour’s level and slope… Read More »Which Hour of the Day Is Slower Than It Used to Be?

A SQL Server overview is built from DMVs that reset, accumulate and exclude things. Here is what each number counts, and what it quietly leaves… Read More »SQL Server Overview: The DMVs Behind Every Number

For the month of October you will receive a free year of our SQL Server Daily Monitoring with the purchase of a SQL Server Assessment.… Read More »Top 10 Techniques to Turbocharge Your SQL Server Performance