YoVDO

Performance Tuning Wisdom Needs Expiration Dates

Offered By: PASS Data Community Summit via YouTube

Tags

PASS Data Community Summit Courses Database Administration Courses

Course Description

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore performance tuning wisdom for SQL Server in this 57-minute conference talk from the PASS Data Community Summit. Join Brent Ozar and Erik Darling as they challenge conventional wisdom and debunk outdated assumptions about database optimization. Dive into demos covering topics such as indexing strategies, scan vs. seek operations, and the effectiveness of various tuning techniques. Learn why some long-held beliefs about performance tuning may need to be reevaluated and discover fresh approaches to improve your SQL Server's efficiency. Gain insights on table scans, filtering, index design, query store, and Azure performance tuning. Understand the importance of regularly updating your knowledge and adapting to evolving best practices in database management.

Syllabus

Introduction
Brent and Eric introduction
Demos
Table scans
Filtering
Indexes
Free Plan Cache
Force Index Seek
Logical Reads
Fill Factor
Drop Indexes
Index on Display Name
Missing Index Hint
Testing Missing Index Hint
Testing Cortana
Stack Overflow Overflow Post
Hash Match
Index Recommendation
Index Scan
Index Design
Order By
Sort
Index
Grouping
Indexing
Missing Index DMV
Sikh
Questions
Issues of change
Tuning indexes
Sorting
Missing Index Requests
Asynchronous Indexing
Brents 5 Rule
Does the 5 Rule Include Columns
Is it better to leave it as a heap
Columnstore vs Columnstore
Querystore
SP Blitz Index
Azure Performance Tuning
Robot Interpretive Dance


Taught by

PASS Data Community Summit

Related Courses

Doing More with Less - The Challenges Ahead for Every Data Professional
PASS Data Community Summit via YouTube
Build a Modern Data Strategy and Put Your Data to Work
PASS Data Community Summit via YouTube
Transform Your Data Estate
PASS Data Community Summit via YouTube
Azure SQL and SQL Server 2022 - Intelligent Database Futures
PASS Data Community Summit via YouTube
SQL Server in Azure Virtual Machines Reimagined
PASS Data Community Summit via YouTube