VMware Communities: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of

Up to Discussions in Virtual Machine & Guest OS

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

Jun 10, 2009 2:14 PM

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

Reply Re: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error Jun 10, 2009 6:15 PM

DLeid 272 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.

Reply Re: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error Jun 11, 2009 5:50 AM

in response to: DLeid

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

View as PDF

Up to Discussions in Virtual Machine & Guest OS