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.
As you face the need to modernize your SQL Server 2008/2008R2, the SQL Server 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.

The video is not available to view online.