On ESXi 5.5 I have 2 x hosts, each host has 12 Cores, 2 socket x 6 core.
We have a bunch of servers running on them and have a total of 70 CPUs allocated out.
Our main DB server currently has 8CPU allocated, however if I drop it down to 4 is struggles.
Given that, over the course of the year and also month by month, we don't use more than an average of 10%
of the total CPU processing power on the ESX hosts, should this be happening?
I'm trying to figure out how many cores we need in our new ESX hosts and I'm confused by the fact that
although we're not using a lot of the overall CPU power, the SQL server struggles if I reduce the core count.
Should it not just take up more of the unused cores?