VMware

This Question is Not Answered

1 "correct" answer available (10 pts) 2 "helpful" answers available (6 pts)
2 Replies Last post: Jun 11, 2009 5:50 AM by SQLDBAVM  

SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error posted: Jun 10, 2009 2:14 PM

Click to view SQLDBAVM's profile Novice
SQLDBAVM
11 posts since
Jun 3, 2009
One VM in this hardware HP Proliant DL 380 G5

Processors: 8 CPU x 2.833 GHz


Processor Type: Intel (R) Xeon(R) CPU E5440 @ 2.83GHz


Hyperthreading: Inactive (This type of processors are not hyperthreaded)


I have been testing the SQL Server here using the DBHammer tool. Everytime I run the test with 2 or 4 virtual processors I get the Out of Memory Error. But if I conduct the same test with only one virtual processor I don't get this error. Since the processors are not Hyper threaded I have configured Advanced CPU - HT Sharing: None. Now can someone tell me what the deal here is that as soon as I increase the number of processors I get this Out of Memory Error. Also if I plan on running the server with only one processor how will my nested and parallel queries perform in SQL with only 1 vCPU?

Tags: esx3.5

Re: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error

1. Jun 10, 2009 6:15 PM in response to: SQLDBAVM
Click to view DLeid's profile Expert
DLeid
273 posts since
Apr 26, 2006

Who is giving the out of memory error? the Windows guest or ESX

What is the memory configuration of the host? Installed and available

What is the memory configuration of the guests? The larger the memory the larger the swap file

It's better to first run your vm with one virtual processor than work your up. ESX does a better job of scheduling the vCPU than Windows. I usually don't have to configure more than one vCPU for 32 Bits but find some 64 bit vm work better with two vCPUs, but have never assigned more than two vCPUs per vm.

Also if I plan on running the server with only one processor how will my nested and parallel queries perform in SQL with only 1 vCPU?

Better for ESX to handle scheduling the processor.

Re: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error

2. Jun 11, 2009 5:50 AM in response to: DLeid
Click to view SQLDBAVM's profile Novice
SQLDBAVM
11 posts since
Jun 3, 2009
Windows Guest is giving out the memory error. The host has 6 GB memory and the VM has 3 GB with this being the only VM in the host. The reason I am giving only 3 GB is to see if I can have one more VM down the line. I am tried to to give all 6 GB to the single VM and it would still throw me the error when I have more that 1 vCPU's assigned to it. Now if I only assign 1 processor to it I don't think I will be using all my resources. Isn't that right? Or is VM smart enough to give extra CPU's when it deems necessary for that particular VM?

Actions

VMware Developer

SDKs, APIs, Videos, Learn and much more in the Developer community.

Learn More

Developer Sample Code

Increase your developer productivity with VMware API sample code.

Learn More

VMworld Sessions & Labs

Online access to the latest VMworld Sessions & Labs and online services.

Learn more

Purchase PSO Credits Online

Purchase credits to redeem training and consulting services online.

Buy Now

Community Hardware Software

View reported configurations or report your own.

Learn More

VMware vSphere

Come witness the next giant leap in virtualization.

Register Today

Communities