An Advanced SQL Server Query Profiling Technique
In this video, I delve into advanced query profiling techniques using SQL Server's built-in dynamic management views and actual execution plans to gain insights during query execution. We explore two different versions of a query-one serial and one parallel-to observe how they behave differently in terms of resource usage and performance. By examining the progress of operators through DMVs like 'sys.dm_exec_query_profiles', we can identify potential issues such as skewed parallelism or inefficient use of CPU resources, providing a deeper understanding of query execution and helping to pinpoint areas for optimization.
CHAPTERS
00:00:00 - Introduction
00:00:29 - Advanced Query Profiling
00:01:29 - Member Support
00:02:59 - Demo Queries
00:03:58 - Dynamic Management Views
00:04:43 - Serial Plan Execution
00:05:21 - Parallel Query Analysis
00:06:11 - Parallel Thread Skew
00:07:33 - Clustered Index Scan Comparison
00:08:44 - Troubleshooting Insights
━━━━━━━━━━━━━━━━━━━━━━━━━━
📚 TRAINING & COURSES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Get AI-Ready With Erik
https://training.erikdarling.com/get-...
SQL Server Performance Engineering Course
https://training.erikdarling.com/sql-...
Learn T-SQL with Erik
https://training.erikdarling.com/lear...
Everything Bundle:
https://training.erikdarling.com/?cou...
━━━━━━━━━━━━━━━━━━━━━━━━━━
🛠️ CONSULTING & SERVICES
━━━━━━━━━━━━━━━━━━━━━━━━━━
Need SQL Server performance help?
https://training.erikdarling.com/sqlc...
━━━━━━━━━━━━━━━━━━━━━━━━━━
💬 CONNECT
━━━━━━━━━━━━━━━━━━━━━━━━━━
Ask questions at Office Hours
https://erikdarling.com/officehours/
Become a channel member
/ @erikdarlingdata
━━━━━━━━━━━━━━━━━━━━━━━━━━