• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 641
  • Last Modified:

VM Guest performance issues

Hi all,

I wonder if anyone had any suggestions for my problem. I have a VM running on vsphere 4.1 (vm version 7).

The server is running server 2003 sp1. The machine is running a SQL database but nothing to intense. At the moment the server is spiking many of its processes so that most of the time 100% of the processor is consumed. The machine is configured with 2gb of RAM, and this maybe where the issue is. If i logon to the server (eventually) the task manager tells me that the server is committing 2gb of RAM, however under the resource window vsphere is telling me that the consumed host memory is 144mb and the active guest memory is 172mb???

This to me is where the problems might be, but im not sure why or what to do. Any help appreciated.
0
MJB2011
Asked:
MJB2011
2 Solutions
 
PMP_AdminCommented:
Does this physical machine have virtualization support settings in the BIOS? what type of processor? number of cores? amount of physical ram in machine? is vsphere a full license or the free one? as vsphere is just a administration software what is the actual host running? ESXi?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
If you check most SQL Servers, Task Manager reports full memory in use, because SQL uses all the memory in the server, and released it back to the OS, when requested.

What is the host memory?

What is the stoage system?

Best Practices for SQL Server
http://communities.vmware.com/docs/DOC-8964

1. Check and correct CPU utilization: CPU Performance Analysis and Monitoring

2. Identify memory bottlenecks and remove: Memory Performance Analysis and Monitoring
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Stop any Anti-Virus
0
Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

 
MJB2011Author Commented:
The configured host memory is 2Gb
consumed host memory is - 141mb
active host memory is - 114mb

Windows taskmgr says its commiting 2gb?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
The ESX server only has 2GB?
0
 
MJB2011Author Commented:
No sorry the esx server has 64gb
0
 
MJB2011Author Commented:
The configured host memory is 64Gb
consumed vm memory is - 141mb
active vm memory is - 114mb

Windows taskmgr says its commiting 2gb?
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
If you have created a VM with 2GB, SQL will use 2GB!

If you check most SQL Servers, Task Manager reports full memory in use, because SQL uses all the memory in the server, and released it back to the OS, when requested.

What storage system is in use by the ESX host?

When does the CPU go high, all the time?

Does Task Manager show 100% all the time, of is it only when queries are being performed?

Do you have any issues with this VM, that users are commenting on?

What process is causing the 100% CPU usage? SQLSERVER.EXE?
0
 
MJB2011Author Commented:
OK, i understand what you are saying about SQL. I am logged intot eh server at the moment at its unusable because the processor is maxed out over a number of different programs running.

What storage system is in use by the ESX host? fibre connection to EVA4000

When does the CPU go high, all the time? once im logged in it max's out. If logged out it calms doen but still spikes to 100% often

Does Task Manager show 100% all the time, of is it only when queries are being performed? AS above. When logged in it shows 100%

Do you have any issues with this VM, that users are commenting on? Slow performance

What process is causing the 100% CPU usage? SQLSERVER.EXE?

Not 1 but many.sqlservr.exe, services.exe, savservices.exe amongst others. Its mainly the SAV service which is consuming around 50%. Although the on-access scanning is off i can kill the program
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Shutdown the Anti-Virus.

Does sound specially like SQL service, was this server built as a VM, it's not a P2V?
0
 
Danny McDanielClinical Systems AnalystCommented:
if you edit the VM's configuration, go to resources tab, and click on memory, is there a limit below 2GB?  If so, set to unlimited (default setting) and do a power cycle (not a reset or restart) on the VM.
0
 
rajkumartechCommented:
set the performance log counter in SQL and check for memory and disk.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now