Query Store

Course Type: On-Demand Course

Curriculum:

Introduction to Performance Tuning Basics

Lecture1.1 Introduction to Performance Tuning Basics Preview 4m
Lecture1.2 Determine your monitoring goals 5m
Lecture1.3 Select the appropriate tools 4m
Lecture1.4 Cardinality Estimation 3m
Lecture1.5 Execution Plan Analysis 4m
Lecture1.6 Analyzing the Data 3m
Lecture1.7 Establish a Performance Baseline 4m
Lecture1.8 Isolate Performance Problems 4m
Lecture1.9 Demo-SQL Server Profiler-Part1 6m
Lecture1.10 Demo-SQL Server Profiler-Part2 5m
Lecture1.11 Demo-Cardinality Estimation-Part1 6m
Lecture1.12 Demo-Cardinality Estimation-Part2 5m

INDEX ARCHITECTURE 0/6

Lecture2.1 Introduction 10m
Lecture2.2 Clustered Index 7m
Lecture2.3 Demo-Clustered Index 6m
Lecture2.4 NonClustered Index 7m
Lecture2.5 Demo-NonClustered Index 7m
Lecture2.6 Indexes with Included Columns 4m

COLUMNSTORE INDEX 0/15

Lecture3.1 Introduction 4m
Lecture3.2 Rowgroup and Column Segment Preview 4m
Lecture3.3 Clustered Columnstore index 5m
Lecture3.4 NonClustered Columnstore index 4m
Lecture3.5 Use of Columnstore index 2m
Lecture3.6 Loading the data into Clustered Columnstore index table 4m
Lecture3.7 Loading the data into NonClustered Columnstore index table 3m
Lecture3.8 Columnstore index for OLTP tables 4m
Lecture3.9 Columnstore index for Data Warehouse tables 4m
Lecture3.10 Resource considerations to implement Columnstore index 3m
Lecture3.11 Demo-Columnstore index -PART1 6m

STATISTICS 0/15

Lecture4.1 Introduction 4m
Lecture4.2 AUTO_CREATE_STATISTICS 2m
Lecture4.3 AUTO_UPDATE_STATISTICS 3m
Lecture4.4 AUTO_UPDATE_STATISTICS_ASYNC 5m
Lecture4.5 When to create STATISTICS-Part1 4m
Lecture4.6 When to create STATISTICS-Part2 5m
Lecture4.7 When to update STATISTICS 4m
Lecture4.8 Queries that use Statistics effectively-Part1 4m
Lecture4.9 Queries that use Statistics effectively-Part2 3m
Lecture4.10 Manual threshold settings to update Statistics 5m
Lecture4.11 Demo-Default Statistics 4m
Lecture4.12 Demo-Update Statistics on Multiple Columns 4m
Lecture4.13 Demo-Filtered-Statistics 4m
Lecture4.14 Demo-Recommendations to create Statistics 5m
Lecture4.15 Demo-Plan guide for Statistics 2m

SQL SERVER DYNAMIC MANAGEMENT VIEWS (DMV'S) 0/11

Lecture5.1 SQL Server DMV’s-PART1 9m
Lecture5.2 SQL Server DMV’s-PART2 4m
Lecture5.3 SQL Server DMV’s-PART3 5m
Lecture5.4 SQL Server DMV’s-PART4 5m
Lecture5.5 SQL Server DMV’s-PART5 5m
Lecture5.6 SQL Server DMV’s-PART6 8m
Lecture5.7 SQL Server DMV’s-PART7 9m
Lecture5.8 SQL Server DMV’s-PART8 8m
Lecture5.9 SQL Server DMV’s-PART9 5m
Lecture5.10 SQL Server DMV’s-PART10 7m
Lecture5.11 SQL Server DMV’s-PART11 5m

IN-MEMORY OLTP OPTIMATION 0/12

Lecture6.1 Introduction 6m
Lecture6.2 Requirements for In-Memory OLTP Optimization 4m
Lecture6.3 Transactions for In-Memory Optimized tables 4m
Lecture6.4 Table Partitions for In-Memory Optimized tables 3m
Lecture6.5 Statistics for In-Memory Optimized tables 4m
Lecture6.6 ROW STRUCTURE for In-Memory Optimized tables 4m
Lecture6.7 Demo-In-Memory Optimization-Part1 4m
Lecture6.8 Demo-In-Memory Optimization-Part2 4m
Lecture6.9 Demo-In-Memory Optimization-Part3 4m
Lecture6.10 Demo-In-Memory Optimization-Part4 6m
Lecture6.11 Demo-In-Memory Optimization-Part5 5m
Lecture6.12 Demo-In-Memory Optimization-Part6 5m

IN-MEMORY OLTP QUERY PROCESSING 0/5

Lecture7.1 Query Processing in Disk based tables 5m
Lecture7.2 Query Processing in In-Memory Optimization-Part1 3m
Lecture7.3 Native Compilation for Tables and Stored Procedures 5m
Lecture7.4 Demo-In-Memory OLTP Query Processing-Part1 4m
Lecture7.5 Demo-In-Memory OLTP Query Processing-Part2 3m

PERFORMANCE MONITORING TOOLS 0/20

Lecture8.1 Introduction to Performance Monitor-Part1 6m
Lecture8.2 Introduction to Performance Monitor-Part2 5m
Lecture8.3 Demo-Performance Monitor-Part1 Preview 6m
Lecture8.4 Demo-Performance Monitor-Part2 5m
Lecture8.5 SSMS-Activity Monitor 2m
Lecture8.6 Demo-SSMS-Activity Monitor-Part1 11m
Lecture8.7 Demo-SSMS-Activity Monitor-Part2 4m
Lecture8.8 Database Engine Tuning Advisor 4m
Lecture8.9 Demo-Database Engine Tuning Advisor-Part1 5m
Lecture8.10 Demo-Database Engine Tuning Advisor-Part2 4m
Lecture8.11 Extended Events 3m
Lecture8.12 Demo-Extended Events 6m
Lecture8.13 Plan Guide 4m
Lecture8.14 Demo-Plan Guide-Part1 5m
Lecture8.15 Demo-Plan Guide-Part2 4h53m
Lecture8.16 Query Store and Live Query Statistics 3m
Lecture8.17 Demo-Query Store and Live Query Statistics-Part-14m
Lecture8.18 Demo-Query Store and Live Query Statistics-Part-23m
Lecture8.19 Demo-Query Store and Live Query Statistics-Part-33m
Lecture8.20 Demo-Query Store and Live Query Statistics-Part-43m