The ask may sound weird but we are seeing sort of awkward behavior. Or may be we do not have historical data to confirm if it is true.

For our 4 sockets 16 core processor SQL server with total of 64 schedulers ( 4 NUMA but with auto soft numa node we see 8) queries coming in are mostly running ( as seen) on certain numa schedulers. For example numa 4,5,6 has 99% queries running there.

Is there a way in XE or something which tracks queries being run uses which scheduler and we can store this info historically?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.