Home > Workload Solutions > SQL Server > Best Practices > Intel-Based SQL Server Best Practices on Dell PowerEdge R750xs and PowerStore 5000T > Server Best Practices > Day 3 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.3 |
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, meaning database performance is an enterprise priority. In this best practice, the CPU Power Management Policy was changed from the default setting 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 showed a very slightly increase in performance for the database.
Although changing the CPU Power Management Policy to high performance did not lead to significant performance improvements, it is still a good practice for production databases and considered a Day 3, Fine Tuning recommendation. 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 perform the following:
Additional Resources
VMware vSphere Documentation: Select a CPU Power Management Policy