Home > Workload Solutions > SQL Server > Guides > Implementation Guide—SQL Server 2019 Best Practices on PowerStore > PowerStore: Volume Performance Policy
The volume performance can be managed in the PowerStore storage array by adjusting the performance policy. Selecting a performance policy sets a relative priority for the volume by using a share based QoS system that prioritizes the higher performance policy when resources are constrained. The performance policy does not impact on system behavior unless some volumes have a low performance policy setting while other volumes are set to medium or high.
Category | PowerStore Storage |
Product | PowerStore 5000T |
Type of best practice | Performance Optimization |
Day and value | Day 3, Fine Tuning |
Overview
A performance policy specifies I/O performance requirements for PowerStore storage resources. PowerStore provides three predefined performance policies:
To determine if changing the volume performance policy provides value, it was tested against the baseline using the default value (medium). In the baseline configuration for the database volumes, the SQL Data, SQL Log, Temp Data, Temp Log, and SQL Backup volumes were configured with a medium performance policy. For this test case, the SQL Data volumes were configured with a high performance policy. Table 13 shows which volumes were configured with a high performance policy.
Additional resources
Dell EMC PowerStore Configuring Volumes
Dell PowerStore: Best Practices Guide
Volume Group | Volume Name | VMware Datastore | Volume Performance Policy | Notes |
SQLVM1 | SQLVM1Data1 | SQLVM1Data1 | High | SQL Data/Log |
SQLVM1Data2 | SQLVM1Data2 | High | ||
SQLVM1Data3 | SQLVM1Data3 | High | ||
SQLVM1Data4 | SQLVM1Data4 | High | ||
SQLVM1Log1 | SQLVM1Log1 | High | ||
SQLVM1Temp | SQLVM1TempData1 | SQLVM1TempData1 | High | Temp Data/Log |
SQLVM1TempLog1 | SQLVM1TempLog1 | High | ||
SQLVM1Backup | SQLVM1Backup | SQLVM1Backup | Medium | Backup |
Recommendation
Changing the performance policy to high for the SQL Data, SQL Log, SQL Temp DB, and SQL Temp Log volumes resulted in no performance gain. Considering these results, this best practice is considered as a Day 3, Fine Tuning practice and benefit only if there are volumes with mixed performance policy on the array.
Implementation steps
To change the volume performance policy for the volumes, use the PowerStore Manager and follow the instructions from the PowerStore manual.