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?