Easy Performance Troubleshooting With Extended Events
2022TL; DR
Troubleshooting complex stored procedure performance is a nightmare, but it doesn't have to be.
Session Details
Troubleshooting complex stored procedure performance is a nightmare, but it doesn't have to be. In this 20 minute talk, I'll show you how you can hit F5 and get everything you need to fix your worst code. Actual execution plans, statement text, parameter values, and more.
3 things you'll get out of this session
Speakers
Erik Darling's previous sessions
The SQL Server Performance Tasting Menu
Delicious Demos For Doubting Developers
What Else Can Indexes Do?
No pictures of phone books, here. We're gonna look at the way indexes change query behavior for better... and worse.
Improving SELECT * Query Performance
For anyone frustrated by column-hoarding users and developers