Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to Compare Estimated and Actual Query Plans.
Create Efficient Query Plans Using Query Store – Analyzing SQL Server Query Plans – Part 3
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss how to Create Efficient Query Plans Using Query Store.
Identify Poorly Performing Query Plan Operators – Analyzing SQL Server Query Plans – Part 2
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Identify Poorly Performing Query Plan Operators.
Capture Query Plans Using Extended Events and Traces – Analyzing SQL Server Query Plans – Part 1
Capture query plans with targeted Extended Events, understand actual plan overhead, and use Query Store for lighter SQL Server history.
Parallel Plans: Reading Gather Streams and Repartition Streams
Read Gather Streams and other parallel exchanges, inspect rows per thread and spill evidence, and relate exchange waits to actual work.
Operator Costs in an Execution Plan: Read Them Without Being Fooled
Interpret operator costs as estimates, compare actual rows and runtime evidence, and find expensive work without trusting plan percentages.
NonParallelPlanReason: Why a Query Refuses to Go Parallel
Read NonParallelPlanReason in actual and cached plans, then check MAXDOP, scalar functions, table variables, and query cost.