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.
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.