Name: Parameter Sniffing in SQL
Start: 2025-12-09T18:00:00-05:00
End: 2025-12-09T19:00:00-05:00

Parameter sniffing in SQL Server eliminates the need to recompile query plans, thereby saving CPU cycles and avoiding plan pollution. While this feature can optimize query performance, it can also lead to unexpected issues if not managed correctly. In this session, we will explore the concept of parameter sniffing, how SQL Server optimizes queries based on parameter values, and common scenarios where it can cause performance problems. We'll discuss various practical strategies to mitigate these issues, including plan guides, Parameter Sensitive Plan optimization, and query hints like OPTIMIZE FOR and OPTION (RECOMPILE), which can now be added to the Query Store without rewriting the code. By the end of this session, you'll have a thorough understanding of parameter sniffing and the techniques to optimize your SQL Server queries for better performance.

Tracy Boggiano

Kevin Feasel

Triangle SQL Server User Group

Technology

SQL Server

Database Development

Business Intelligence

Data Management

Database Professionals

Data Visualization

Advanced SQL Server

Predictive Analytics

Machine Learning

Data Science

IT Professionals

Data Analytics

Big Data

Torsten (MVP, MCSE, MCT) has been working with Microsoft SQL Server since the turn of the millennium and is specialized in performance optimization for large SQL Server environments.

He has been with bp as a database engineer for over two decades and collaborates closely with Sarpedon Quality Lab as a Principal Microsoft SQL Server Consultant.

Torsten has given more than 250 presentations on Microsoft SQL Server performance optimization at national and international conferences and user groups.

Torsten has been recognized as a Microsoft Most Valuable Professional for Data Platform since 2018.

Torsten Strauß

Parameter Sniffing in SQL

Online event

Share

Triangle SQL Server User Group

Parameter Sniffing in SQL

Triangle SQL Server User Group

Details

Members are also interested in