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
About the authors
Vinod Kumar has worked with SQL Server extensively since joining the industry over a decade ago. Before joining Microsoft, he was a Microsoft MVP for SQL Server for more than 3 years. He now works with MTC as a Technology Architect. He is a well-known speaker at all major Microsoft and third party technical conferences.
Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 21 years of hands-on experience. He holds a Master of Science degree and numerous database certifications. Pinal has authored 14 SQL Server database books and 61 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,700 database tech articles on his blog at https://blog.sqlauthority.com.