Add CPU cores to VMware vSphere 4+ VM …

Staff have been complaining about a SQL application call Total Synergy running slow. There are a lot of factors here that might be impacting but in my search for answers, I came across an SQL monitoring app called Ignite. It is created by Confio (www.confio.com/performance/sql-server/ignite/). Although no SQL expert, this tool seemed to suggest that CPU resources were lacking. I already knew how to add CPU’s to a VM. The problem is that I am running SQL Express 2008 R2. It only supports a single CPU but this can be a maximum 4 core CPU. Fortunately, I discovered that since vSphere 4.x, it has been possible to add CPU cores to a VM. Here is the VMware knowledge base article:

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1010184

I should clarify that in 4.0, which I am running, it is experimental. However, for the moment it is holding up and feedback suggests it has made some difference. Now, to sort out some of the other possible impacts – network, storage etc……

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: