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

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

English | MP4 | AVC 1280×720 | AAC 44KHz 2ch | 1h 27m | 252 MB

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.

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 it’s time to start using them! Microsoft has invested a lot of effort in these tools that can automate areas of performance tuning and give you time to work on more interesting and creative tasks that can’t be automated. In this course, SQL Server: Automatic Tuning in SQL Server 2017 and Azure SQL Database, you’ll learn how Query Store has been upgraded to also collect wait statistics from queries, to allow you to identify performance bottlenecks at the query level and dig deeper to resolve them. Next, you’ll explore Automatic Plan Forcing, which allows SQL Server to identify queries where performance has regressed and automatically force a prior query plan that is more efficient. Finally, you’ll take a dive into Automatic Index Management, which gives SQL Server the capability to automatically create missing indexes and remove unused or duplicate indexes. By the end of this course, you’ll have the skills and knowledge to start enabling these features in appropriate parts of your SQL Server environment and taking back some of your precious time!

Table of Contents

01 – Course Overview
02 – Introduction and Query Store in SQL Server
03 – New Functionality in SQL Server 2017 and Azure SQL Database
04 – Course Objectives, Structure, and Module Summary
05 – Introduction and What Are Waits
06 – Wait Statistics DMVs and 2016 Enhancements
07 – Wait Statistics and Query Store
08 – Demo – Using Wait Statistics in Query Store
09 – Relationship Between Plans and Statistics, and Module Summary
10 – Introduction and Forcing Plans with Query Store
11 – Automatic Plan Correction
12 – Demo – Automatic Plan Correction in Action
13 – Unforcing a Plan, Monitoring, and Module Summary
14 – Introduction, Indexes, and Automatic Index Management
15 – How Automatic Index Management Works
16 – Demo – Using Automatic Index Management – Part 1
17 – Demo – Using Automatic Index Management – Part 2
18 – Module Summary and Course Summary