Performance

Parameter Sniffing — When the Same Plan Works for One Parameter but Not Another

2026-11-10 · 2 min

A practical introduction to parameter sniffing in SQL Server: how to identify and measure the problem and when to consider PSP, RECOMPILE, or other approaches.

Connection Pool V2 in Microsoft.Data.SqlClient — Faster Does Not Always Mean Faster

2026-11-05 · 8 min

A hands-on SQL Server 2022 and .NET 10 benchmark: 500 randomized trials, 200–500 connection diagnostics, and PerfView CPU analysis. When does Pool V2 win or lose?

Query Store After Migration — How to Detect Execution Plan Regressions

2026-11-03 · 2 min

Use SQL Server Query Store after migration to compare plans, identify regressions, and respond safely to performance problems.