SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database

by Erin Stellato

There’s a whole new world of automated features in SQL Server, based on data, that are designed to make life easier for the data professional and in this course you’ll learn everything you need to know to start using them.

• Course Overview 1m 48s
• Introduction 8m 20s
• Introduction and Query Store in SQL Server2m 48s
• New Functionality in SQL Server 2017 and Azure SQL Database3m 37s
• Course Objectives, Structure, and Module Summary1m 54s
• Finding and Using Wait Statistics in Query Store28m 11s
• Introduction and What Are Waits?1m 43s
• Wait Statistics DMVs and 2016 Enhancements3m 7s
• Wait Statistics and Query Store2m 10s
• Demo: Using Wait Statistics in Query Store17m 21s
• Relationship Between Plans and Statistics, and Module Summary3m 48s
• Using Automatic Plan Correction21m 11s
• Introduction and Forcing Plans with Query Store1m 55s
• Automatic Plan Correction3m 27s
• Demo: Automatic Plan Correction in Action12m 26s
• Unforcing a Plan, Monitoring, and Module Summary3m 22s
• Using Automatic Index Management27m 43s
• Introduction, Indexes, and Automatic Index Management3m 17s
• How Automatic Index Management Works3m 55s
• Demo: Using Automatic Index Management – Part 110m 7s
• Demo: Using Automatic Index Management – Part 26m 46s
• Module Summary and Course Summary3m 36s

Level Intermediate
Duration 1h 27m
Released 9 Jan 2018

download