BRK3155 – Practical guidance to make your tier-1 SQL Server roar

Whether you are new to managing SQL Server or a seasoned database administrator, you may be unsure of the latest and greatest recommendations for configuring and maintaining a high-performance tier-1 database system. In this session, the SQL Tiger team lays out the current guidance for configuring and tuning SQL Server on modern, high-end hardware. Topics include, but are not limited to, tempdb configuration, disk configuration, memory configuration, trace flags, Query Store, tools, automatic tuning, and index/stats maintenance.