0

We are in the middle of a migration and moving from SQL 2012 Enterprise to SQL 2019 Standard (due to licensing costs) and I have recently encountered this issue using sp_blitz.

Here is what the VM looks like originally

With the results looking like this , notice offline schedulers. I have been working with my VM team to reconfigure but not sure they or I 100% understand this correctly to resolve.

schedulers offline

They have changed the server to now show 8 sockets , 16 Virtual Processors New Configuration

with select * from sys.dm_os_schedulers showing this

New Results

I am not familiar with the VM configuration to know exactly what to tell them. I think this change has improved (somewhat) but it still doesnt seem like SQL is taking advantage of everything on the VM.

Users have been complaining of performance on the migrated applications and I think this is the issue as the underlying hardware is much more powerful than the old 2012 VM's.

1 Answer 1

3

You've configured the VM with 1 core per socket and 8 sockets. Standard Edition can only see the first four sockets. Change the configuration to 1 socket with 8 cores.

NUTS

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.