Home > Workload Solutions > SQL Server > Guides > Implementation Guide—SQL Server 2019 Best Practices on PowerStore > Best practices
To enhance the value of best practices, we have identified which configuration changes produced the greatest results. We ranked the best practices to help our customers easily identify which recommendations have the most value. Most enterprises implement configuration changes based on the delivery cycle. Best practices were categorized as follows:
Day 1 through 3:
Highly, moderately, and fine-tuning recommendations: Customers want to understand the impact of the best practices and these terms are used to indicate the value of each best practice.
When reviewing the best practices, the day and value of the recommendations are combined. Here are some examples:
The goal of this ranking system is to help customers to quickly decide which recommendations will provide the best value. For example, two or three best practices from the section on CPU optimization might provide most of the value for a customer depending on their goals. Investing the time to implement these best practices provides the greatest return. This approach can be taken for each layer of the database system until all Day 1, highly recommended best practices are completed. This methodology makes best practices unique and provides a way for customers to have the best return on investment.
Best practices are broad recommendations that apply to most SQL Server environments using Dell infrastructure, but it is important to recognize every database application workload and environment is different, meaning the value of these best practices will vary from system to system. As with any configuration or change to a database system, the best approach is to validate the change before implementing the best practice on a production system. For this reason, we recommend testing all best practices before implementing the changes in production.