Question about CPUAFFINITYMODE and CPUAFFINITYSET
Suppose I have two different resource pools with CPUAFFINITYSET=80% in shared mode.
What will happen to the second resource pool if the first one reaches to 80% CPU usage? will the second pool's queries be queued or will the server reach 100% CPU?
Thank you !