Home > Workload Solutions > SQL Server > Best Practices > AMD-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 setting.
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 it’s 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 CPU Power Management Policy of balanced.
Although there were no significant performance, changing the CPU Power Management Policy to high performance is a good practice for production databases. In changing the power management policy to high performance, the administrator ensures no power management features will impact future performance.
Implementation Steps
Use the following steps to update the power policy to high performance:
Additional Resources