[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 805
  • Last Modified:

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

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.
0
PESTKILLERS
Asked:
PESTKILLERS
  • 2
  • 2
2 Solutions
 
gheistCommented:
Is it signal waits or IO waits?
0
 
PESTKILLERSAuthor Commented:
cxpacket waits.  They're in the 66% range
0
 
gheistCommented:
http://msdn.microsoft.com/en-us/library/ms179984.aspx
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.
0
 
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
0
 
PESTKILLERSAuthor Commented:
turns out the cxpacket waits were not really an issue.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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