Adding virtual CPUs to Server 2003/SQL 2005
Posted on 2012-03-12
vmWare ESXi 4
Several VM's, all running Windows Server 2003 32-bit
The SQL VM was originally configured (not by me) with only 1 virtual cpu (Xeon 2.5GHz) and with 4GB RAM.
This machine is taking strain as it runs 8 SQL databases (various sizes, largest one being about 8GB).
I need to increase this VM's performance and am toying with the idea of adding at least one more virtual CPU as this CPU runs at or above 90% for most of the day.
Since the OS is 32-bit, I cannot realistically add more RAM to it (...or can I in this virtual environment?)
VMWare says that adding a cpu to a VM may cause instability - the last thing I need is for this server to becme unstable, so the big question is: can I do this safely?
My other option would be to create another SQL VM and spread the databases accross the 2VM's, but as my datastore space is limited it may be a tight fit.
Anyone have any advice/guidance for me?