Tweak the VM settings to use 1 socket and just add cores to spread the SQL load.
Tuesday 20 August 2013
SQL Server Express High CPU Utilization
If you've got a SQL Express VM which has sqlsvr.exe maxing out the CPU regularly, you could do worse than tweak your CPU configuration. SQL Express is limited to 1 CPU or 4 cores, so if your VM is setup with 2 sockets, SQL will only a ever use one of them.
Subscribe to:
Posts (Atom)