VM taking HIgh CPU

Posted on 2012-08-27
Last Modified: 2012-08-30
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?


Question by:Prashant Girennavar
    LVL 33

    Assisted Solution

    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.
    LVL 10

    Author Comment

    by:Prashant Girennavar
    SO is there any testing needs to be performed , before increasing the vCPU.

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


    -Prashant Girennavar.
    LVL 33

    Expert Comment

    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.

    LVL 116

    Accepted Solution

    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

    and some SQL databases DO NOT do well under any Hypervisor, and this is to be expected.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    The original payload size or maximum transmission unit (MTU) of an ethernet frame is 1500 bytes. A jumbo frame has an ethernet frame size of 9000 bytes or over. Common Jumbo Frame sizes are 9000, 9216 bytes (example - HP switches). Enabling Jumb…
    This article is an update and follow-up of my previous article:   Storage 101: common concepts in the IT enterprise storage This time, I expand on more frequently used storage concepts.
    Teach the user how to use create log bundles for vCenter Server or ESXi hosts Open vSphere Web Client: Generate vCenter Server and ESXi host log bundle:  Open vCenter Server Appliance Web Management interface and generate log bundle: Open vCenter Se…
    This Micro Tutorial steps you through the configuration steps to configure your ESXi host Management Network settings and test the management network, ensure the host is recognized by the DNS Server, configure a new password, and the troubleshooting…

    761 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

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now