Why’s This Query So Slow in Prod? Check sp_BlitzPlanCompare.

· Brentozar · Oct. 21, 2026, 1:44 p.m.
Summary
This blog post discusses the performance discrepancies between development and production servers for SQL queries, highlighting common causes such as parameter sniffing and different database-level settings. The author suggests using 'sp_BlitzPlanCompare' to analyze and diagnose the slow queries in production environments.