Lots of people had no idea that even index can also reduce the performance of SELECT queries. In this blog, we discuss 3 follow up questions.
Plan Cache Memory by Cache Store: Where Plans Use Your RAM
Break down plan cache memory by cache store and object type, compare memory clerks, and investigate unused plans without cache clearing.
Columnstore Deleted Rows: When the Delete Bitmap Slows Scans
Inspect columnstore deleted rows, measure delete-bitmap overhead, and choose targeted REORGANIZE work before a heavier rebuild.
SQL SERVER – Getting Started with Accelerated Database Recovery – Instant Rollback
Killing a long transaction used to mean a rollback that took forever. SQL Server 2019 fixes that with Accelerated Database Recovery and its instant rollback.
SQL SERVER – How Do I Evaluate Monitoring Tools?
Today, I am going to talk about the 3 important properties which I look for in all the SQL Server Performance monitoring tools.
SQL SERVER – Script to Get Compiled Plan with Parameters From Cache
A script I use in every Health Check: get the compiled plan with parameters from cache, so you can see what values the plan was built for.
Capturing Actual Execution Plans From a Script With SET STATISTICS XML
Capture actual plans with SET STATISTICS XML, save the extra result safely, inspect runtime fields, and compare last-known plan statistics.