From How Parallel Execution Works:
The number of parallel execution servers in one set is the degree of parallelism (DOP)
What is the meaning of "one set" in the document? Does it have a relationship with user session? My understanding is that one session has only one set, two sessions have two sets, and the total session's execution servers is limited by parallel_servers_target. Is that correct?
Best Answer
That quote is definitely unclear. I interpret "one set" to be one set of operations, which is also called a data flow operation in the context of a parallel plan. One parallel query may have more than one data flow operation, so one session may contain more than one set. I recommend reading Understanding Parallel Execution - Part 1: