Turbo Boost Performance by 3 Configurations Changes in 60 Seconds

Speaker: Pinal Dave

Level: 300

DBAs and Developers often work across multiple versions of the SQL Server. It is not possible for to know every single configuration settings introduced in the new version of SQL Server. To keep the predictable behavior SQL Server many of the newly introduced settings are kept off or disabled. In this fast-paced demo-oriented session we will see three critical and the most important configurations settings once enabled instantly give a performance to SQL Server. We will further explore these settings to understand how they work on the cloud and have a comprehensive understanding of the SQL Server’s performance. In the first 60 seconds of the session, we will understand how we can enable 3 important settings of SQL Server which can improve SQL Server performance by multifold.