SQL Server Performance: Introduction to Query Tuning
SQL Server performance tuning is an art to master - for developers and DBAs alike. This course takes a systematic approach to planning, analyzing, debugging and troubleshooting common query-related performance problems. This includes an introduction to understanding execution plans inside SQL Server.
You are currently not signed in. Please sign in to access subscriber-only content.
Currently using: {{getCurrentPlayerName()}} [Change]
| expand all | collapse all | Progress | Duration | |
|---|---|---|---|
 Introduction |
|
00:10:22 | |
|
Introduction
|
|
02:58 | |
|
Query Tuning
|
|
02:38 | |
|
Demo
|
|
04:46 | |
|
Execution Plan Basics |
|
00:45:59 | |
|
Introduction
|
|
04:01 | |
|
Demo
|
|
05:58 | |
|
Various Execution Plan Types
|
|
03:04 | |
|
Demo: Execution Plan Types
|
|
05:24 | |
|
Clustered Index
|
|
04:23 | |
|
Demo: Clustered Index
|
|
04:08 | |
|
Non-clustered Index
|
|
01:42 | |
|
Demo: Non-clustered Index
|
|
03:50 | |
|
Key Lookup
|
|
00:48 | |
|
Demo: Key Lookup
|
|
03:19 | |
|
Index Seek vs Index Scan
|
|
01:42 | |
|
Types of Joins
|
|
01:54 | |
|
Demo: Types of Joins
|
|
04:33 | |
|
Summary
|
|
01:13 | |
|
Essential Indexing Techniques |
|
00:20:19 | |
|
Introduction
|
|
03:54 | |
|
Demo: Basics of Index
|
|
03:25 | |
|
Index Behaviors
|
|
00:59 | |
|
Demo: Seek vs Scan vs Lookup
|
|
04:58 | |
|
Demo: Usage of Functions in WHERE clause
|
|
04:49 | |
|
Summary
|
|
02:14 | |
|
Query Design for Performance |
|
00:50:16 | |
|
Introduction
|
|
02:04 | |
|
EXISTS vs IN vs JOIN
|
|
02:48 | |
|
Demo: EXISTS vs IN vs JOIN
|
|
09:57 | |
|
Common Table Expression (CTE)
|
|
01:01 | |
|
Demo: Common Table Expression (CTE)
|
|
04:11 | |
|
Order of Table and Query Hints
|
|
01:14 | |
|
Demo: Order of Table and Query Hints
|
|
05:40 | |
|
Plan Guide and Parameter Sniffing
|
|
01:34 | |
|
Demo: Plan Guide and Parameter Sniffing
|
|
05:33 | |
|
Dynamic SQL and Performance
|
|
01:03 | |
|
Demo: Dynamic SQL and Performance
|
|
04:53 | |
|
User Defined Functions, Views and Performance
|
|
01:57 | |
|
Demo: UDFs, Views and Performance
|
|
07:39 | |
|
Summary
|
|
00:42 | |
|
Performance Tuning Tools |
|
01:15:14 | |
|
Introduction
|
|
01:41 | |
|
SSMS Performance Dashboard
|
|
01:13 | |
|
Demo: SSMS Performance Dashboard
|
|
10:40 | |
|
Demo: Error Logs
|
|
03:03 | |
|
Demo: SQL Server Best Practices Analyzer
|
|
03:48 | |
|
Demo: Database Tuning Advisor
|
|
06:59 | |
|
Demo: Perfmon Counters
|
|
06:09 | |
|
Demo: Performance Analysis of Logs (PAL) Tool
|
|
06:00 | |
|
Demo: SQL Space Map
|
|
02:21 | |
|
Demo: SQL Server Profiler
|
|
09:06 | |
|
Demo: SQL Server Extended Events
|
|
04:21 | |
|
SQL Server Wait Stats
|
|
03:14 | |
|
Demo: SQL Server Wait Stats - CXPACKET
|
|
05:15 | |
|
Demo: Wait Stats - Identify Offending Query
|
|
02:18 | |
|
Demo: Dynamic Management Views (DMV)
|
|
05:30 | |
|
Demo: SQLDiag
|
|
03:02 | |
|
Summary
|
|
00:34 | |
|
Tips and Tricks |
|
00:25:53 | |
|
Introduction
|
|
01:13 | |
|
Demo: Columnstore Index
|
|
02:26 | |
|
Demo: Functions and Computed Columns
|
|
01:35 | |
|
Demo: Cursors and Performance
|
|
03:21 | |
|
Demo: Multi Statement Table Value Functions
|
|
03:33 | |
|
Demo: Stored Procedure and Dynamic Query
|
|
02:42 | |
|
Demo: Stored Procedure and Transaction
|
|
02:04 | |
|
Demo: Stored Procedure and Compilation
|
|
03:26 | |
|
Demo: Performance Tips and Tricks
|
|
05:33 | |
|
Checklist: Performance Tuning |
|
00:07:13 | |
|
Checklist
|
|
07:13 |
