Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > Market environment
One of the biggest issues customers face with is how to fine-tune the recommended settings. This does not mean that the SQL Server solution will perform optimally after the first attempt. This solution performance optimization process requires constant observations and testing to come up with a set of best practices for the whole solution. To achieve this milestone, each component in the solution must be tuned individually and then combined with other components to ensure that all changes work in harmony. Those components in the infrastructure solution consist of:
In addition, this tuning exercise must be done on a separate environment such as test or dev to avoid any problems that could arise when implemented on production. Since performance tuning is an art and the best practices derived from the initial testing may not fit for every workload, patience and time are required to come up with the right set of best practices that can be beneficial in the end.