Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > Best practices category
All best practices are not created equal. To enhance the value of best practices, we have identified which configuration changes produced the greatest results. This should enable anyone reviewing the best practices to easily identify the recommendations that will have the most value. Best practices were categorized as follows:
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, however 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. We recommend testing all best practices before implementing the changes in production.