SQLBits 2015

Parameter Sniffing Problem with Stored Procedures

Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and we will offer several solutions for this problem and discuss which solution is applicable in which scenario.

Your stored procedure is slow in the application, but works perfect in SSMS! In this presentation it will be clarified why this happens and why parameter sniffing is a problem in SQL Server stored procedures. Of course we will offer several solutions for this problem and discuss which solution is applicable in which scenario.

Speaker

Milos Radivojevic is a database developer and consultant, speaker, and trainer located in Vienna, Austria. He is Microsoft SQL Server MVP and MCT and specializes in SQL Server for application developers. He is co-leader of the SQL Server PASS Austria

Milos Radivojevic's Sessions

When to stop tuning a query

Dealing with Very Large Tables in SQL Server

Parameter Sniffing Problem with Stored Procedures

Transact SQL Performance Tips

TSQL Performance Tips

Parameter Sniffing Problem with Stored Procedures

TSQL Performance Recommendations