Home > Workload Solutions > SQL Server > Best Practices > Intel-Based SQL Server Best Practices on Dell PowerEdge R750xs and PowerStore 5000T > Storage Best Practices > Day 1 Best Practices > VMware vSphere: Using vVols for SQL Server 2019
Virtual Volumes (vVols) is a new VMware technology that is supported starting in vSphere 6.0. This best practice validates that using VMware vVols for SQL Server 2019 optimizes database performance and management.
Category | VMware vSphere |
Product | VMware vSphere 7.3 |
Type of best practice | Performance Optimization |
Day and value | Day 1, Highly recommended |
Overview
vVols are VMDK granular storage entities exported by storage arrays. vVols are exported to the ESXi host through a small set of protocol end-points (PE). PEs are part of the physical storage fabric that establish a data path from virtual machines to their respective vVols on demand. Storage systems enable data services on vVols.
A key feature of vVols is that it allows administrators to use storage policy-based management (SPBM) for their environment. This enables you to align application requirements with the appropriate storage resources in an automated manner.
Recommendation
Use vVols for simplified storage management to automate storage provisioning and space reclamation. vVols performance should be on par with VMFS. However, vVols provides better snapshotting performance than VMFS because it uses the array snapshot functionality. Snapshot is frequently used in a SQL Server environment, which means vVols should be considered over VMFS.
Based on our test results, this practice is considered as a Day 1, Highly Recommended best practice.
Additional Resources
Understanding Virtual Volumes (vVols) in VMware vSphere 6.7/7.0 (2113013)