Apostolisep3
Contributor
Contributor

sql server 2017 on vsphere 6.5

Jump to solution

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!

0 Kudos
1 Solution
2 Replies