VM taking HIgh CPU

Hello Experts,

  We are having a Virtual machine (SQL Server ) which is taking high CPU. I have checked the process which are running and the process which is cosuming the high CPU.

 SQLservr is the process which is taking around 80% of CPU usage , Since it is the SQL server I can not delete the threads of this services.

 I am planning to increase the vCPU for this machine. Currently it has only 1 vCPU.

 THe server has 4 GB of RAM.

 What are your thoughts on this?

Thanks,

_Prashant_
LVL 10
Prashant GirennavarAsked:
Who is Participating?
 
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor VMware and Virtualization ConsultantCommented:
1. Check you are not running on a Snapshot

see my EE Article
HOW TO: VMware Snapshots :- Be Patient

2. Check Processor Contention and Memory
see my EE Article
HOW TO:  Performance Monitor vSphere 4.x or 5.0

3. Check datastores, what datastores are in use? RAID 1, RAID 10, SATA?

4. SQL using Complex Queries?

5. Is the database indexed?

6. SQL Best Practice Guide
http://communities.vmware.com/docs/DOC-8964

and some SQL databases DO NOT do well under any Hypervisor, and this is to be expected.
0
 
BusbarConnect With a Mentor Solutions ArchitectCommented:
1 vCPU is too little, give it 2 and check and depending on your load you might need to increase it to 2.

generally the CPU thing needs testing.
0
 
Prashant GirennavarAuthor Commented:
SO is there any testing needs to be performed , before increasing the vCPU.

If Yes , Can you please let me know about testing?

Thanks,

-Prashant Girennavar.
0
 
BusbarSolutions ArchitectCommented:
what do you mean from SQL, I don't think so other than recording the current CPU load and time and then adding the vCPU and see how it went.

Mahmoud
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.

All Courses

From novice to tech pro — start learning today.