Currently using SQL Server 2012 Standard edition on a Hyper-V hosted VM running Windows Server 2012 R2.
The VM has 4 vCPUs assigned.
Have been informed by the SQL DBAs that to increase performance we would need to increase the number of vCPUs and consequently upgrade the version of SQL from Standard to Datacenter to make use of them.
Is this accurate?
My confusion comes in that this is a virtual machine and how the OS and also SQL sees and utilizes the CPUs.
Additional, and perhaps useful, information:
The physical host has (2) x 10 Core CPUS
The NUMA configuration in the VM is:
NUMA nodes: 1