<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:clearspace="http://www.jivesoftware.com/xmlns/clearspace/rss" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:opensearch="http://a9.com/-/spec/opensearch/1.1/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>VMware Communities: Message List - SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error</title>
    <link>http://communities.vmware.com/community/vmtn/general/vm-guest?view=discussions</link>
    <description>Most recent forum messages</description>
    <language>en</language>
    <pubDate>Thu, 11 Jun 2009 12:50:40 GMT</pubDate>
    <generator>Clearspace 1.10.12 (http://jivesoftware.com/products/clearspace/)</generator>
    <dc:date>2009-06-11T12:50:40Z</dc:date>
    <dc:language>en</dc:language>
    <item>
      <title>Re: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error</title>
      <link>http://communities.vmware.com/message/1280623?tstart=0#1280623</link>
      <description>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?</description>
      <pubDate>Thu, 11 Jun 2009 12:50:40 GMT</pubDate>
      <author>SQLDBAVM</author>
      <guid>http://communities.vmware.com/message/1280623?tstart=0#1280623</guid>
      <dc:date>2009-06-11T12:50:40Z</dc:date>
      <clearspace:dateToText>5 months, 2 weeks ago</clearspace:dateToText>
    </item>
    <item>
      <title>Re: SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error</title>
      <link>http://communities.vmware.com/message/1280079?tstart=0#1280079</link>
      <description>&lt;br /&gt;
Who is giving the out of memory error? the Windows guest or ESX &lt;br /&gt;
&lt;p /&gt;
&lt;p /&gt;
&lt;p /&gt;
What is the memory configuration of the host? Installed and available&lt;br /&gt;
&lt;p /&gt;
What is the memory configuration of the guests? The larger the memory the larger the swap file&lt;br /&gt;
&lt;p /&gt;
 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.&lt;br /&gt;
&lt;p /&gt;
&lt;p /&gt;
&lt;p /&gt;
&lt;i&gt;&lt;span style="color:#ff0000"&gt;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?&lt;/span&gt;&lt;/i&gt;&lt;br /&gt;
&lt;p /&gt;
Better for ESX to handle scheduling the processor.</description>
      <pubDate>Thu, 11 Jun 2009 01:15:09 GMT</pubDate>
      <author>DLeid</author>
      <guid>http://communities.vmware.com/message/1280079?tstart=0#1280079</guid>
      <dc:date>2009-06-11T01:15:09Z</dc:date>
      <clearspace:dateToText>5 months, 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>1</clearspace:replyCount>
    </item>
    <item>
      <title>SQL Server 2000 in ESXi 3.5 Build 153875 Responding with Out Of Memory Error</title>
      <link>http://communities.vmware.com/message/1279445?tstart=0#1279445</link>
      <description>One VM in this hardware HP Proliant DL 380 G5 &lt;br /&gt;
&lt;br /&gt;
Processors: 8 CPU x 2.833 GHz &lt;br /&gt;
&lt;p /&gt;
&lt;br /&gt;
Processor Type: Intel (R) Xeon(R) CPU E5440 @ 2.83GHz&lt;br /&gt;
&lt;p /&gt;
&lt;br /&gt;
Hyperthreading: Inactive (This type of processors are not hyperthreaded) &lt;br /&gt;
&lt;p /&gt;
&lt;br /&gt;
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?</description>
      <pubDate>Wed, 10 Jun 2009 16:24:23 GMT</pubDate>
      <author>SQLDBAVM</author>
      <guid>http://communities.vmware.com/message/1279445?tstart=0#1279445</guid>
      <dc:date>2009-06-10T16:24:23Z</dc:date>
      <clearspace:dateToText>5 months, 2 weeks ago</clearspace:dateToText>
      <clearspace:replyCount>2</clearspace:replyCount>
    </item>
  </channel>
</rss>

