Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > 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.
Table 18. Best practice category
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 slight 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.
Additional Resources
VMware vSphere Documentation: Select a CPU Power Management Policy