Solved

Adding virtual CPUs to Server 2003/SQL 2005

Posted on 2012-03-12
10
792 Views
Last Modified: 2012-03-14
Scenario:
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?
0
Comment
Question by:Altra
  • 4
  • 3
  • 3
10 Comments
 
LVL 120
ID: 37710146
You can certainly try and add another CPU to the Virtual Machine, and see if it helps you performance.

The amount of RAM you have allocated to this VM seems, low, what version of Windows 2003 Server do you have?

because 32bit could be limited to 4GB only, depending upon version.

see here

http://msdn.microsoft.com/en-us/library/windows/desktop/aa366778%28v=vs.85%29.aspx
0
 
LVL 14

Expert Comment

by:RickEpnet
ID: 37710147
It depends on how the server's HAL was setup originality. Can it handle multiple CPUs. How was the machine setup in the first place as a VM or a physical machine?
0
 
LVL 120
ID: 37710157
I think it would be wise to setup a new VM, with single processor and as much ram as you require. Maybe select a 64 bit VM.

If you cannot increase the memory in the VM, what memory is in use currently?
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:Altra
ID: 37710323
Thanks for the responses:

The VM is running Windows Server 2003 Standard R2 32-bit (with SP2).

As far as I know the VM was originally set up as a VM, not a physical machine, and looking at the timeframe, it made sense to do it that way, but with the company's expansion, in retrospect it was possibly under-specced, and unfortunately it is only Standard Edition, so it looks like I am limited to the 4GB I have curently.

I would like to add a vCPU to see if this alleviates the problems, I'm just worried about stability.

Ideally I would like to go to Server 2008 x64 but I need to work on the client quite a bit to convince him to spend the money, so it is not an option at the moment.
0
 
LVL 120

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 37710402
You will be fine adding another CPU.

Make sure the VM is off.

Add A CPU
Add another CPU, when the VM restarts, you may need to start Device Manager, select CPU, and select Upgrade and select the Multi Processor HAL, and then restart.

It should not cause stability issues, but may not give you the results you expect.
0
 
LVL 14

Expert Comment

by:RickEpnet
ID: 37710439
Is the server utilizing all the RAM right now? Do you have multiple databases do you have multiple incidents of SQL running or are all the databases running under the same incident?
0
 

Author Comment

by:Altra
ID: 37713451
hancocka: Thanks - stability query answered ok. Will add the cpu and see what happens. I do accept that it may not do all I need it to do, but if it alleviates the almost constant 100% cpu usage I'll be happy. Users are experiencing lagginess and hanging when using the app that depends on these databases - and I've drawn a correlation that cpu usage is pegged at 100% when they experience this lag.

RickEpnet: There are 8 databases all running on one instance of SQL and memory usage is not horribly high - usually around 50% to 75%
0
 
LVL 14

Assisted Solution

by:RickEpnet
RickEpnet earned 250 total points
ID: 37715755
Then adding the CPU is you best chance beside going with a 64 bit server.
0
 

Author Comment

by:Altra
ID: 37718668
Great, thanks - going 64-bit is first prize, but since the client is not going to spend money on that right now, I'll settle for second...
0
 

Author Closing Comment

by:Altra
ID: 37719382
To the point, just what I was looking for.
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
VMware vSAN 6.5 usage example and caveats 11 148
VMware Fail Over 5 84
HTA with vb script to restart specific windows services 12 63
VAAI  technology 2 56
When converting a physical machine to a virtual machine using VMware vCenter Converter Standalone or vCenter Converter Enterprise, if an adapter type is not selected during the initial customization the resulting virtual machine may contain an IDE d…
In this article, I will show you HOW TO: Create your first Windows Virtual Machine on a VMware vSphere Hypervisor 6.5 (ESXi 6.5) Host Server, the Windows OS we will install is Windows Server 2016.
Teach the user how to join ESXi hosts to Active Directory domains Open vSphere Client: Join ESXi host to AD domain: Verify ESXi computer account in AD: Configure permissions for domain user in ESXi: Test domain user login to ESXi host:
With the advent of Windows 10, Microsoft is pushing a Get Windows 10 icon into the notification area (system tray) of qualifying computers. There are many reasons for wanting to remove this icon. This two-part Experts Exchange video Micro Tutorial s…

680 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question