Parameter Sniffing Archives - Page 5 of 5 - SQL Authority with Pinal Dave

This month's discount Comprehensive Database Performance Health Check Testimonials

Two identical brass compasses on a workbench, one needle pulled aside by a nearby iron vise

Why One Query Has Two Cached Plans: SET Options and plan_attributes

November 8, 2008

SQL Performance

Execution Plan, Parameter Sniffing, SQL Cache, SQL DMV, SQL Server

Investigate two cached plans with plan_attributes, decode differing SET options, and match application settings before diagnosing skew.

A rope swing on an oak branch holding a heavy sack of sand, the rope taut, tested before anyone rides it.

Stress Testing a Query Before Release

December 19, 2007

SQL Performance

Parameter Sniffing, SQL Performance, SQL Server, SQL Wait Stats, Testing

Stress testing a query before release reveals concurrency and parameter risks; learn to design realistic SQL Server tests and compare useful metrics.