Query Store

############################# Video Source: www.youtube.com/watch?v=yhEG7iEwwRU

Learn SQL Server 2014/2016 Performance Tuning Training and Query Optimization Course within affordable price at http://xtraguru.com/courses/sql-serve... • 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

#############################

New on site