Home > Workload Solutions > SQL Server > White Papers > SQL Server 2019 Best Practices on PowerEdge Servers and PowerStore T Model Arrays > Conclusion
The Dell Integrated Solutions team developed, validated, and consolidated the SQL Server 2019 database best practices on 15G PowerEdge servers with Intel® processors, PowerSwitch, and PowerStore 5000T storage. Improving customer outcomes continues to be a key tenet across all SQL Server solutions and the validated best practices demonstrate how Dell Technologies is committed to ensuring customer success.
These SQL Server 2019 best practices represent a comprehensive, consolidated set of recommendations that include everything from the physical infrastructure to the software stacks. For our customers, this simplifies best practice identification and offers significant time savings in optimizing database performance.
We categorized the best practices using performance metrics from HammerDB, the database, servers, and storage. The goal was to categorize best practices based upon their value in terms of improving performance.
By grouping best practices by their return on performance, we streamline how customers can achieve the best results in the shortest time. This reduces complexity and risk by providing a plan our customers can follow: Day 1 followed by Day 2 and, if needed, Day 3 best practices.