Mastering Parameter Sniffing
You're a database developer or DBA with at least 3 years experience performance tuning queries and indexes.
You already know you have parameter sniffing issues, and now you need to figure out how to fix it. In this one-day class, you'll learn how to reduce the blast radius with index changes, query tuning, and database-level settings. You'll also see firsthand how SQL Server 2017, 2019, and 2022 try to reduce it with adaptive joins, adaptive memory grants, automatic tuning, and caching multiple plans.
This course is 100% demos: the only slides are the introduction and recap. The rest of the time, we'll be working live in SQL Server Management Studio and SQL Server 2019. You can even follow along in your laptop if you bring SQL Server 2017 or newer and the 50GB Stack Overflow 2013 database.
Starts: 09:00 8th Mar 2022
Ends: 17:00 8th Mar 2022
- Learn how to reduce the blast radius with index, query, and server tuning.
If so what Spec?
- Optionally, if attendees want to bring a laptop, 4 CPU cores or more, 16GB RAM or more. It's not required at all - attendees can watch medoing the demos onscreen - but if they want to answer their own questions by doing experiments, it can help to follow along on one's own laptop.
What software and licences do they need?
- SQL Server 2017 or newer, Developer Edition 50GB Stack Overflow 2013 database
What is the structure of the day?
- This course is 100% demos: the only slides are the introduction and recap. The rest of the time, we'll be working live in SQL Server Management Studio and SQL Server 2022. You can even follow along in your laptop if you bring SQL Server 2017 or newer and the 50GB Stack Overflow 2013 database.
What internet requirements do the delegates have?
What will the delegates get out of the day?
- * Learn how to spot the common places where plans diverge: parallelism, memory grants, index selection, and join types * Learn how to capture good, bad, and terrible plans with the plan cache and Query Store * Learn ways to mitigate parameter sniffing with index changes, query tuning, and database-level settings * Learn how SQL Server 2017, 2019, and 2022 try (and usually fail) to reduce it with Adaptive Joins, Adaptive Memory Grants, and Automatic Tuning
The SQL Bits Story
SQLBits was formed in 2007 by a group of volunteers who were passionate about the SQL Server product suite and wanted to provide much-needed community-driven education to the data community.
As one of the largest data platform conferences in the world, we offer more opportunities to a wider audience.
We’ve grown and expanded a lot since 2007.
SQLBits is the best place to meet fellow data professionals.
We welcome data professionals from all over the globe.
1140 recorded sessions
All the live sessions are recorded and offered for free, year round.
Experience the SQLBits Conference
Want to be part of the SQLBits community?
Attend the London conference in-person or virtually on