Solved

SQL 2005 VM on ESXi 4 will not use more CPU resources from host.

Posted on 2012-03-27
10
488 Views
Last Modified: 2012-10-09
We have SQL 2005 running on Windows Server 2003 as a VM on an ESXi 4 host.  The host started off with single socket 4 core CPU.  Due to high CPU utilization, we added a second socket 4 core CPU.  The VM is running by itself on the host.  What is happening is, when you look at the CPU usage in windows its stilll high averaging 80%-90%.  If you look at the performance tab of the VM in ESXi its also reporting 80% plus.  However if you look at the performance tab of the host itself without any other VMs assigned, it only reports about 35% usage.  The VM is set to 4 vCPU and the host itself has 2 socket of 4 core totaling 8.  Any ideas?
0
Comment
Question by:autocrib
  • 4
  • 4
  • 2
10 Comments
 
LVL 119

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 250 total points
ID: 37772786
whats the issue?

poor SQL performance, slow queries?

was performance poor with 1 vCPU?

adding many vCPU can have a detrimental effect?

if you have single VM only, why not just install on Bare Metal, with hypervisor?
0
 
LVL 40

Expert Comment

by:coolsport00
ID: 37772842
The issue could be memory, not CPU; Since you're using 2K3, & if you're using 32bit, you only have a 4GB limit. That could be the problem... (but, also depending upon license Edition - Ent, DC, etc)

~coolsport00
0
 

Author Comment

by:autocrib
ID: 37772872
Of course when it peaks at 100% we have sql requet timeouts, the server was converted with the existing 4 cpu so we left it at 4 vCPU.  This has been running fine at this setting for years.  We of course have grown and added load to the SQL server.  Is it a good idea to set it back to only one vCPU at this point? We converted to a virtual enviroment to take advantage of seamless hardware upgrades and management so no way we are going back to bare metal.
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 

Author Comment

by:autocrib
ID: 37772902
No we can rule out RAM or disk usage ever since we upgraded to 32GB and 64bit editions of both 2003 and sql 2005, disk usage have dropped to barely anything and we have ample RAM available.  The only thing that have steadily climb over the years have been CPU usage.  I believe this is more of a ESXi issue then windows or SQL.  Any ESXi experts out there?
0
 
LVL 119
ID: 37772913
Yes move the SQL database off the ESXi server, and it will solve your issue.
0
 
LVL 40

Assisted Solution

by:coolsport00
coolsport00 earned 250 total points
ID: 37772924
It could be the host. Sometimes DBs don't play nice with vSphere. Same goes with Terminal Services. Can they run on vSphere? Sure. Is it supported. Absolutely. But, is it the best for resource? No, not necessarily...
0
 
LVL 119
ID: 37772968
We have been working with clients and moving, via Virtual to Physical conversions at moving SQL servers from virtual to physical servers, because the Hypervisor sucks to much resources from the SQL server on bare metal.

So if the performance of your database as a virtual machine does not meet your requirements I would suggest the same course of action.

As an example we used a HP DL360 G5, Dual Processor Quad Core 3.0GHz, 32GB RAM, single virtual machine with 8GB RAM, 2 vCPU.

Querys took 13 minutes to respond, flatlined the VM at 100%, and also the Host.

Same configuration without the hypervisor, queries were instant, no CPU issues.

It was permamently migrated back to a physical VM. Adding additional resources, cpu, memory, did notbhelp.
0
 
LVL 119
ID: 37773024
Video of the Performance we experienced on troublesome SQL VM

Video - Poor Microsoft SQL Performance caused by Virtualisation - Not all servers are equal!
0
 

Accepted Solution

by:
autocrib earned 0 total points
ID: 38464430
Upgrading to ESXi 5 enabled the option for the VM to user 8vcpu.  It now allows for the single VM to fully utilize both socket and all 8 cores.  Usage on the host went from 100% down to 60% usage.  Thanks for you input but it was a ESXi issue and we are running fine with MS SQL 2005 now.
0
 

Author Closing Comment

by:autocrib
ID: 38476670
The issue was with ESXi 4 and the particular hardware compatibility.  The experts comments was on the course of getting away from virtualization which was not an option for us.
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

This article will show you how to create an ISO CD-ROM/DVD-ROM image (*.iso), and MD5 checksum signature, for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5). It's a good idea to compare checksums, because many installations fail because of a corr…
In this article, I will show you HOW TO: Suppress Configuration Issues and Warnings Alert displayed in Summary status for ESXi 6.5 after enabling SSH or ESXi Shell.
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

776 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