Hello all,
we have a 2017 sql server on a VM running on 64gb of ram with 8 CPU , 4 cores per socket giving us 2 sockets and 8 logical processors.
when i run a script to rebuild the indexes on multiple databases i can see the CPU going up to 100% and staying there permanently till the VM crashes.
i read something about NUMA nodes but i am not sure how to configure them...
any help with this?
thank you!
Thank you very much Mike!