Autoplay
Autocomplete
Previous Lesson
Complete and Continue
SQL Performance Tuning
Course Introduction
Welcome and Overview (0:59)
Why performance tuning is important
Reducing licensing costs with performance tuning (2:49)
Making this course
How to get the most out of this course (0:32)
Query Optimization
Execution Plan Overview
Introduction to Execution Plans Presentation (10:47)
Viewing Execution Plans (20:24)
Intro to Execution Plans Demo (16:59)
Execution Plan Operator Details (14:36)
Statistics IO and Statistics Time (7:11)
Sargability
What is sargability?
Sargability Demo (19:50)
Smells
Introduction to Code Smells (1:06)
Functions in the WHERE clause (8:21)
More details Functions in the WHERE Clause
Parameter Sniffing and Query Recompilation
Implicit Conversions (7:16)
Database Design Considerations
Choosing appropriate data types and column sizes
Normalization techniques
Denormalization
Partitioning strategies for large tables
Indexing Strategies
Index Overview
Different Types of Indexes in SQL Server (11:37)
Index Design Best Practices (1:27)
Statistics Maintenance
Index Maintenance
Dangers of Maintenance Plan Wizards
Index Scan versus Seek
Covering Indexes
Removing Indexes - Danger (2:03)
Performance Monitoring
Database Health Monitor (9:21)
DMV's
Analyzing wait statistics and query execution statistics
Finding Blocking Queries (11:37)
Isolation Levels
Isolation Levels Overview
Isolation Levels Video (7:49)
NOLOCK and Read Uncommitted
Read Committed
Serializable
RCSI
Performance Tuning Techniques
TempDB Optimization
Temp Tables and Table Variables
Missing Index Recommendations
Missing Index Recommendation Overview
Database Tuning Advisor
SQL Performance Monitor - Part of Database Health Monitor (4:28)
Benchmarking and Baselines
Establish a baseline (2:38)
Server Settings
Max Degree of Parallelism (4:27)
Cost Threshold for Parallelism (3:39)
Optimize for Ad Hoc Workloads (2:29)
Danger - Priority Boost
Sharding for Large Systems
Sharding in SQL Server (4:27)
Review - Wrap Up
Database Health Monitor Course
Course Completion Certificate
Teach online with
Parameter Sniffing and Query Recompilation
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock