One of my repeat clients asked me if a query goes to parallel do they use all the threads. We can have parallelism and thread with no work.
During the recent Comprehensive Database Performance Health Check, my client asked me if I have a query which can list all the parallel queries.
One of the interesting question: Is it possible to Override Server’s Configuration of Max Degree of Parallelism? Of course, it is possible, let us read.
Today we see T-SQL Script to Identify TOP 10 Parallel Running Queries which I wrote as a part of my Comprehensive Database Performance Health Check.
Question: Do Stream Aggregate Operator Always Need Sort Operator?
Answer: Absolutely No.Before I explain this question a bit more in detail.
Is Stream Aggregate is Same as Gather Streams of Parallelism? – This was one of the brilliant questions I had received during my recent engagement.