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

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_
0
Prashant Girennavar
Asked:
Prashant Girennavar
  • 2
2 Solutions
 
BusbarCommented:
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
 
BusbarCommented:
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
 
Andrew Hancock (VMware vExpert / EE MVE^2)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

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

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