CPU settings for SQL Server Databases on VMWare VSphere 5.1 with SQL 2008 Standard

Posted on 2014-07-14
Last Modified: 2014-07-21
We have done a P to V migration of our SQL Server 2008 box.  This box houses our LOB ERP application and we're trying to optimize the CPU and CORE settings in VMWARE 5.1.

Can anyone offer suggestions for optimizing the Database with respect to socket and CORE configurations.  We recently installed a monitoring tool called SQL Sentry and was advized that our CPU Waits were quite high.  

The physical box is very good - Dual 6 core CPUs with 200 gig of RAM.  There's no other heavy load virtual servers on this physical host.  

Just looking for some good guidelines to assist in improving performance.
    LVL 61

    Expert Comment

    Is it signal waits or IO waits?

    Author Comment

    cxpacket waits.  They're in the 66% range
    LVL 61

    Accepted Solution

    Occurs with parallel query plans when trying to synchronize the query processor exchange iterator. If waiting is excessive and cannot be reduced by tuning the query (such as adding indexes), consider adjusting the cost threshold for parallelism or lowering the degree of parallelism.

    i.e parallel sub-queries dont return at same time, so query results for some of them.
    Adding more CPUs will add to non-determinism and rise ths type of wait.
    I'd suggest limiting paralellism per query in server say 2CPUs and see if cx waits go down.
    LVL 116

    Assisted Solution

    by:Andrew Hancock (VMware vExpert / EE MVE)

    Author Closing Comment

    turns out the cxpacket waits were not really an issue.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    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 tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    794 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