sqlservr.exe cpu running high in SBS2011

Posted on 2012-09-18
Last Modified: 2012-09-23
  I have a w neSBS2011 STD. as Virtual iMachine n Windows 2012 Hyper-V manager.
  For some reason CPU utilitziation was constantly between 20% to 70%.
  I noticed sqlservr.exe was occupying over 4GB and CPU% was average 45% constantly.
  In SLQ Studio management, I adjusted RAM to 250MB from the max. memory which was some astronomical. I rebooted SBS2011 and noticed that CPU utilization runs still just as high, but the memory was down to 400MB instead of 4GB.
  I do not use any sql applications on this SBS2011.
  How can I kill this CPU usage?
  I would appreciate specific steps for me to follow instead of links.

Question by:sglee
    LVL 56

    Accepted Solution

    First, undo what you did. SQL needs memory. Yes, it will take any free memory you give it, so 4gb is not abnormal, but it will give it back as needed. Limiting it only hurts performance. And setting the limit as low as you have, anything under a gig really, will actually cause problems, as in crashes. it just wasn't designed to be constrained that tightly.

    Secondly, the processor utilization lies. As a VM, the "processor" the VM sees is itself virtualized, so hyoer-v only gives the processor as many cycles as it estimates the vm needs, this makes the usage in the vm look higher than it really is. To properly measure CPU usage, you must use hyoer-v performance counters. and for the re ord, all hypervisors have similar habits when viewed within the guest vm. So this isn't hyper v specific.

    Author Comment

    I restored the setting. Last night when I turned on the machine, it was not as high as the other night. I will continue to monitor CPU util % on VMs SBS2011.
    It was strange that only SBS2011 VM was running high CPU util% whereas other VMs were 0-1%. These VMs are not being used right now because they have not been delivered to production environment yet. So I was expecting 0% from all VMs.
    I will continue to monitor it.
    LVL 56

    Expert Comment

    by:Cliff Galiher
    The SBS monitoring and reporting feature is always running, so unlike your other VMs, SBS will a,ways be "busy" even in a lab scenario. Again, what you are seeing is not at all unexpected nor a cause for concern,

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 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

    17 Experts available now in Live!

    Get 1:1 Help Now