PASS logo

November 15-18

Seattle & online

2021 Summit video library

SQL Server Performance Features and Best Practices for DBAs

David Pless

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 database system. In this session, we will outline the current guidance for configuring and tuning SQL Server to maximize your SQL Server investment. Topics include, but are not limited to, tempdb configuration, disk and memory configuration, database configuration, Query Store, and index/statistics maintenance.

We will also make special note of the features that can provide the most benefit for modern SQL Server environments.

This session is a must for all database administrators and developers looking to take advantage of all modern features and capabilities in SQL Server.