I am having issues with a new sqlserver 2019 server.
It is a virtual server running on 2 cores and 6 logical cores with 64GB ram.
It seems to not be maxing out the cpus, for example when I do a rebuild of a clustered column store index on the old server, the activity monitor shows cpu usage at 97% and DB I/O at 90MB/s.
The new server only gets 50% and 20MB/s, and takes 3 times as long.
I also noticed that the cube processing sql plans are not using parallelism.
I don't know anything about VM side of things, but my sys admin says everything is fine.
Is there any settings that can be tweaked to improve the performance?
Thanks