I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss Capture Query Plans Using Extended Events and Traces.
Analyzing SQL Server Query Plans – Pluralsight Online Video Course
I got the opportunity to work on the area of SQL Server Performance Tuning have built a video course on the topic of Analyzing SQL Server Query Plans.
Do Stream Aggregate Operator Always Need Sort Operator? – Interview Question of the Week #240
Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.
SQL SERVER – Is Stream Aggregate is Same as Gather Streams of Parallelism?
Is Stream Aggregate is Same as Gather Streams of Parallelism? – This was one of the brilliant questions I had received during my recent engagement.
SQL SERVER – 3 Different Ways to Explore Actual Execution Plans
We will explore 3 different ways to explore Actual Execution Plans. I had discussed this Comprehensive Database Performance Health Check.
SQL SERVER – Number of Rows Read Per Threads in Parallel Operations
Question received via email: The question was about is there any way to know how many rows each thread execute in parallel operations.
SQL SERVER – Get Last Known Actual Execution Plan for a Previously Cached Query Plan
This feature works with SQL Server 2019 and onwards. If you are using an earlier version of SQL Server this feature will not work and will give you an error. One of the most common questions I receive during Comprehensive Database Performance Health Check is how to get the last known actual execution plan for a previously cached query plan.