<div>
Is it signal waits or IO waits?
</div>


<div>
cxpacket waits. &nbsp;They're in the 66% range
</div>


cxpacket waits.  They're in the 66% range

<div>
turns out the cxpacket waits were not really an issue.
</div>


turns out the cxpacket waits were not really an issue.

<div>
<div class="content wysiwyg-content">
We have done a P to V migration of our SQL Server 2008 box. &nbsp;This box houses our LOB ERP application and we're trying to optimize the CPU and CORE settings in VMWARE 5.1.<br />
<br />
Can anyone offer suggestions for optimizing the Database with respect to socket and CORE configurations. &nbsp;We recently installed a monitoring tool called SQL Sentry and was advized that our CPU Waits were quite high. &nbsp;<br />
<br />
The physical box is very good - Dual 6 core CPUs with 200 gig of RAM. &nbsp;There's no other heavy load virtual servers on this physical host. &nbsp;<br />
<br />
Just looking for some good guidelines to assist in improving performance.
</div>
</div>


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.

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

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

VMware, a software company founded in 1998,  was one of the first commercially successful companies to offer x86 virtualization. The storage company EMC purchased VMware in 1994. Dell Technologies acquired EMC in 2016. VMware’s parent company is now Dell Technologies.

VMware has many software products that run on desktops, Microsoft Windows, Linux, and macOS, which allows the virtualizing of the x86 architecture.  Its enterprise software hypervisor for servers, VMware vSphere Hypervisor (ESXi), is a bare-metal hypervisor that runs directly on the server hardware and does not require an additional underlying operating system.