Pier Giuseppe Mandosi | SQL Server Performance Diaries

Oliver Buchannon

Pier Giuseppe Mandosi

SQL Server DBA specializing in performance tuning. Real cases, real execution plans, real numbers

One Record Delete by PK

Jun 4, 2026

•

3 min read

One Record Delete by PK

11 Million Logical Reads

Pier Giuseppe Mandosi

A Single NVARCHAR Parameter Caused 5 Million Logical Reads Per Execution

May 17, 2026

•

1 min read

A Single NVARCHAR Parameter Caused 5 Million Logical Reads Per Execution

The fix was one configuration property. No database changes

Pier Giuseppe Mandosi

2,835 logical reads, 10 after the fix

May 10, 2026

•

1 min read

2,835 logical reads, 10 after the fix

One missing INCLUDE column removed the Key Lookup and cut logical reads by 99.6%.

Pier Giuseppe Mandosi