YoVDO

New Paradigm for Performance Tuning in SQL Server 2016

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Relational Databases Courses Database Administration Courses Performance Tuning Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore a groundbreaking approach to performance tuning in SQL Server 2016 with expert Robert Davis in this 55-minute conference talk from PASS Data Community Summit. Delve into the world of slow queries and learn how to leverage the Query Store feature for efficient plan comparison and analysis. Discover techniques for matching operations, capturing query data, and evaluating resource consumption. Through a comprehensive demonstration, gain insights into tracking queries with multiple plans, comparing execution strategies, and identifying top IO consumers. Master the art of analyzing average duration and execution time to optimize your database performance. Conclude with a summary of key takeaways and participate in a Q&A session to further enhance your understanding of this new paradigm in SQL Server performance tuning.

Syllabus

Intro
Slow Queries
Query Store
Plan Compare
Matching Operations
Querystore
Demo
Query Store Capture
Resource Consumption
Execution Time
Average Duration
Top 10 IO Consumption
Query with more than one plan
Track Queries
Compare Plans
Compare Query Plans
Summary
Questions


Taught by

PASS Data Community Summit

Related Courses

MongoDB for DBAs
MongoDB University
Optimizing Performance for SQL Based Applications
Microsoft via edX
App Deployment, Debugging, and Performance
Google Cloud via Coursera
Application Deployment, Debug, Performance 日本語版
Google Cloud via Coursera
Optimize TensorFlow Models For Deployment with TensorRT
Coursera Project Network via Coursera