Definition: High-end systems
A "high-end system" typically has multiple sockets, eight cores or more per socket, and a half terabyte or more of memory.
How to apply recommended updates and improve SQL Server performance
- Table 1 contains the most frequently recommended updates and trace flags for scalability on high-end systems.
- Table 2 contains recommendations and guidance for additional performance tuning.
- Table 3 contains information about changes in behavior and default settings in SQL 2017 and 2016.
- Table 4 contains additional scalability fixes that were included together with a cumulative update (CU).
- Table 5 contains recommended fixes and configuration guidelines for SQL Server instances deployed in a Linux environment.
If you enabled the trace flags that are listed in this Knowledge Base article for SQL 2014 and 2012, make sure that you review the information in that article after you run the migration to SQL Server 2017 or SQL Server 2016. Many of the trace flags and configuration options that are listed in that article became default options in SQL Server 2017 and SQL Server 2016.