Which database uses the most buffer pool? Queries on sys.dm_os_buffer_descriptors to find SQL Server Memory use by database and by object.
Grouping by query_hash to Find Cheap Queries That Cost the Most
Group cached statements by query_hash to find high total CPU and reads, compare plan hashes, and account for missing cache history.
How to Find Recent Executed Queries in SQL Server? – Interview Question of the Week #087
An interview question that stumped candidates: how do you find recent executed queries in SQL Server? A DMV script using sys.dm_exec_query_stats answers it.
Recovering Unsaved Query Windows After SSMS Closes Unexpectedly
A restart ate your script, but maybe not all of it. Two places to look: SSMS recovery files and the text SQL Server remembers.
Buffer Cache Hit Ratio: Why a Healthy Number Can Lie
A 99 percent ratio does not mean your memory is fine. Here is how to read the counter correctly and what to check beside it.
OPTIMIZED_SP_EXECUTESQL in SQL Server 2025: Fewer Compile Storms
Test OPTIMIZED_SP_EXECUTESQL in SQL Server 2025, inspect compilation counters and cached plans, and compare a concurrent workload.
The Last Actual Execution Plan: LAST_QUERY_PLAN_STATS in Practice
Capture the last actual execution plan with LAST_QUERY_PLAN_STATS, inspect runtime rows, and understand what cache retention cannot provide.