Solved

Windows 2003 Enterprise 32bit VM RAM can't go beyond 4GB & increasing vCPU slows VM

Posted on 2013-06-21
3
1,263 Views
Last Modified: 2013-06-22
We have P2V'ed a Win2003 SP2 that run SQL 2005 to VM &
then run some batch jobs (SQL & Stored Procedures) that we
previously ran in the physical servers with same parameters
as what they used to run while on physical server for
comparison purpose to see if performance improves.

The SAN LUN which hold the DB is presented over to the
VM so that the P2V'ed VM can access it as RDM.  Results of
the test showed it takes about the same amt of time.

Thereafter we shut down the VM, did 'Edit Settings" &

a) double the number of cores (to double the vCPU )

b) double the RAM to 8GB

After bootup, we noted under Computer Properties, the
# vCPU did double but the RAM stays at 4GB.


Q1:
We did enable PAE on the Win 2003 but why is it the amt
of RAM did not reflect as 8GB?  I can send you a screen
shot of the PAE setting if needed.

The link below indicates that with /PAE, it's suppose to be
able to go up to 64GB.


Q2:
We then reran exactly the same stored procedure & SQL
jobs (with exact same parameters) but this time, it took
5-30% longer with one of the job giving the same amt
of timing.  What could be the reason.  The peak CPU for
this VM was 17% only while the jobs are being run as we
used Performance Chart to monitor while it's being run.
I read that increasing vCPU could be bad for performance
in some cases (in one past EE thread that I saw) : under
what circumstances will it be slower?
0
Comment
Question by:sunhux
  • 2
3 Comments
 
LVL 117

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE)
Andrew Hancock (VMware vExpert / EE MVE) earned 490 total points
Comment Utility
Q1. Windows Server 2003, Enterprise Edition maximum limit is 64 GB, this assumes Limits over 4 GB for 32-bit Windows assume that PAE is enabled.

see here

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

Q2. It is also true, that additional vCPUs can slow a virtual machine down, if the application does not support multiple CPUs e.g. vSMP.

We have also seen, SQL server performance dip, and get worse, when they have been moved to a hypervisor. We spend alot of our time performing V2P moving virtual servers to physical servers, because SQL can perform poorly on a hypervisor.
0
 

Author Comment

by:sunhux
Comment Utility
Ok, I've just got the operator to send me the boot.ini of this
Win 2003 Standard (sorry, I made a mistake to say it's Win2003
Enterprise earlier, but it's actually Standard edition) :

[boot loader]
timeout=30
default=multi(0)disk(0)rdisk(0)partition(1)\WINDOWS
[operating systems]
multi(0)disk(0)rdisk(0)partition(1)\WINDOWS="Windows Server 2003, Standard" /fastdetect /NoExecute=OptOut / PAE /3GB

So what's wrong with the above boot.ini ? Is it due to /NoExecute=OptOut
and the /3GB switches that stops the VM from recognizing the additional
RAM granted?
0
 
LVL 117

Accepted Solution

by:
Andrew Hancock (VMware vExpert / EE MVE) earned 490 total points
Comment Utility
Windows Server 2003, Standard Edition the maximum is 4 GB!

This is to be expected upgrade the version from Standard to Enterprise.
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
Veeam Backup & Replication has added a new integration – Veeam Backup for Microsoft Office 365.  In this blog, we will discuss how you can benefit from Office 365 email backup with the Veeam’s new product and try to shed some light on the needs and …
Teach the user how to install and configure the vCenter Orchestrator virtual appliance Open vSphere Web Client: Deploy vCenter Orchestrator virtual appliance OVA file: Verify vCenter Orchestrator virtual appliance boots successfully: Connect to the …
Teach the user how to use vSphere Update Manager to update the VMware Tools and virtual machine hardware version Open vSphere Client: Review manual processes for updating VMware Tools and virtual hardware versions: Create a new baseline group in vSp…

743 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now