Home > Workload Solutions > SQL Server > Best Practices > Intel-Based SQL Server Best Practices on Dell PowerEdge R740 and PowerMax 2000 > CPU Best Practices > VMware vSphere: Power Management Policy
The ESXi Power Policy enables the VMware vSphere administrator to assign a power profile to the virtualized database. In this best practice, we select the high-performance power policy.
Category | VMware vSphere |
Product | VMware vSphere 7.0 |
Type of best practice | Performance Optimization |
Day and value | Day 3, Fine Tuning |
Overview
There are four CPU Power Management Polices that can be selected for a virtual machine:
Many databases support critical business functions where performance is an enterprise priority. In this best practice the CPU Power Management Policy was changed from its default of balanced to high performance to ensure the best possible performance.
Recommendation
The results from changing the CPU Power Management Policy from balanced to high performance did not show any significant increases in performance. All the performance metrics below were similar to the default CPU Power Management Policy (balanced).
Although changing the CPU Power Management Policy to high performance did not lead to significant performance improvements, it is a good practice for production databases. By changing the power management policy to high-performance, the administrator ensures that no power management features will impact future performance.
Implementation Steps
To set the ESXi Power Policy to High Performance, log in to the vSphere and do the following:
Additional Resources
VMware vSphere Documentation: Select a CPU Power Management Policy