Home > Workload Solutions > SQL Server > Guides > Implementation Guide—SQL Server 2019 Best Practices on PowerStore > 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 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 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 as 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 do the following:
Additional resources
VMware vSphere Documentation: Select a CPU Power Management Policy