SQLBits encompasses everything from in-depth technical immersions to the enhancement of valuable soft skills. The full agenda will be announced in the spring; in the meantime check out the timetable and content we cover below.
2024 Training Days
Presenting 2024’s selection of training days, encompassing a deep dive into a range of subjects with some of the best data trainers in the world.
- 08:00 Registration opens and breakfast served.
- All training days run simultaneously across the venue from 09:00 – 17:00 with co-ordinated breaks.
- All training days include regular refreshment breaks and a lunch stop to rest, recharge, and chat to fellow delegates.
- No evening events planned, but if you’re staying over the night beforehand, why not join us in the Aviator on Monday night to meet the training day speakers for an informal drinks reception.
Solving Common Performance Problems Using Query Store
Description
One of the best new features of SQL Server 2016 is Query Store; it’s a game-changer for data professionals. Have you ever had that emergency where you’re informed “The database is slow! It was fine yesterday! Nothing changed!”? How often have you wished for a query’s baseline metrics so that you could quickly compare pre- and post-upgrade performance? Have you ever flailed about querying DMV after DMV to figure out the *real* problem with performance?
It’s time to stop reacting; it’s time to let Query Store help.
In this full-day workshop we’ll dive into the internals of Query Store and cover configuration; the data it captures; and how to use it analyze performance, find regressions, and force plans. The demos will teach you how to interrogate the data to find common patterns in query performance using T-SQL and visualization techniques, and how to take advantage of the wait statistics information captured. Finally, we will end the day working with the Automatic Tuning feature in SQL Server 2017, so you can see how to free up your time for other tasks. You’ll leave this class with the skills to find and leverage important information in Query Store to make query tuning easier.
Pre-requisites
Familiar with the plan cache and query plans, query optimization, and performance monitoring
Laptop Required:No
Learning Objectives
Previous Experience
Tech Covered
performance