SESSION Details

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.

https://sqlb.it/?6180

Starts: 09:00 8th Mar 2022
Ends: 17:00 8th Mar 2022

Q&As

Short Description
- 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?
- None
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

Slidedeck Link

Mastering_Parameter_Sniffing.pdf

Speakers

Brent Ozar

Tags

Platform AgnosticOperational DatabasesOptimisingManaged InstanceSQL 2019SQL 2022AdvancedHow