Urgent.News

the world's headlines, one feed

Editions

More in Tech

Why Is My SQL Query Slow Only in Production? (The Parameter Sniffing Trap)

It’s every developer's favorite Friday afternoon nightmare: A user complains that a feature in the app is hanging. You take the exact SQL query executed by the application, paste it into SQL Server…

  • Parameter sniffing causes slow SQL queries in production only
  • SQL Server compiles execution plan based on initial parameter values
  • Detect problematic plans using dynamic management view (DMV)