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.