SQL Server Performance Tuning and Optimization, Workshops

SQM01 Workshop: Performance Tune SQL Server: Query Optimizer, Indexes, the Plan Cache, and Execution Plans

12/05/2016

8:00am - 5:00pm

Level: Introductory to Intermediate

Bradley Ball

Sr. Consultant – Premier Support for Developers

Microsoft

Do you want to understand how to write awesome queries? Did you ever write a query, only to have the results go horribly wrong? Have you encountered queries that didn't perform and you had no idea how to fix them? This full day Pre-conference workshop will review how to fix these situations. You will dive into how the query optimizer actually works. Then you'll review execution plans and the hidden treasure trove of the plan cache. You will learn to find execution plans by index dependencies, test T-SQL and index improvements, to get results. At the end of the day, you will review the Query Store in SQL Server 2016 and how you can use it to take performance tuning to a new level. You will learn how to diagnose and troubleshoot your SQL Database using a set of scripts and techniques to determine your best options for improving performance.