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.
What you'll learn
SQL Server performance tuning is an in-depth topic, and an art to master. A key component of overall application performance tuning is query tuning. Writing queries in an efficient manner, and making sure they execute in the most optimal way possible, is always a challenge. The basics revolve around the details of how SQL Server carries out query execution, so the optimizations explored in this course follow along the same lines.
Table of contents
- Introduction 2m
- EXISTS vs IN vs JOIN 3m
- Demo: EXISTS vs IN vs JOIN 10m
- Common Table Expression (CTE) 1m
- Demo: Common Table Expression (CTE) 4m
- Order of Table and Query Hints 1m
- Demo: Order of Table and Query Hints 6m
- Plan Guide and Parameter Sniffing 2m
- Demo: Plan Guide and Parameter Sniffing 6m
- Dynamic SQL and Performance 1m
- Demo: Dynamic SQL and Performance 5m
- User Defined Functions, Views and Performance 2m
- Demo: UDFs, Views and Performance 8m
- Summary 1m
- Introduction 2m
- SSMS Performance Dashboard 1m
- Demo: SSMS Performance Dashboard 11m
- Demo: Error Logs 3m
- Demo: SQL Server Best Practices Analyzer 4m
- Demo: Database Tuning Advisor 7m
- Demo: Perfmon Counters 6m
- Demo: Performance Analysis of Logs (PAL) Tool 6m
- Demo: SQL Space Map 2m
- Demo: SQL Server Profiler 9m
- Demo: SQL Server Extended Events 4m
- SQL Server Wait Stats 3m
- Demo: SQL Server Wait Stats - CXPACKET 5m
- Demo: Wait Stats - Identify Offending Query 2m
- Demo: Dynamic Management Views (DMV) 6m
- Demo: SQLDiag 3m
- Summary 1m
- Introduction 1m
- Demo: Columnstore Index 2m
- Demo: Functions and Computed Columns 2m
- Demo: Cursors and Performance 3m
- Demo: Multi Statement Table Value Functions 4m
- Demo: Stored Procedure and Dynamic Query 3m
- Demo: Stored Procedure and Transaction 2m
- Demo: Stored Procedure and Compilation 3m
- Demo: Performance Tips and Tricks 6m