Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 638
  • 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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