A high-end system typically has multiple sockets, eight cores or more per socket, and a half terabyte or more of memory.
Note for SQL Server 2016 and later versions
Many trace flags mentioned in this article is the default behavior and you don’t have to enable them in those versions. See the corresponding Knowledge Base article (KB4465518) for those versions on which configurations to change to achieve maximum performance.
How to apply the recommended updates and improve the performance of SQL Server 2012 and SQL Server 2014
- 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 additional scalability fixes that were included together with a cumulative update.
- DBCC (Transact-SQL)
- Trace Flags (Transact-SQL)
- How to obtain the latest service pack for SQL Server 2012
- Where to find information about the latest SQL Server builds
- SQL Server community resources on important updates for SQL Server