I have an ESXi server running with a Windows 2008 installation on it. It has 2 vCPU's and it runs a SQL Express installation for a database wich is used for my ERP software.
For some reasy 1 core is peaking 100% and the other one is doing nothing mainly.
How can tell my SQL server to use both cores or even more cores if needed?
I have read the SQL Express can use 4 cores on 1 processor, but i can't find it how to enable this.
Anyone with an idea?