In this session, we'll discuss two of the most talked about and discussed features of SQL Server 2017: Adaptive Query Processing and Automatic Tuning. DBAs around the world often worry that once Adaptive Query Processing and Automatic Tuning are fully integrated into the workflow and application development their job will be redundant.
In this session, we'll unfold all the mystery around Adaptive Query Processing and Automatic Tuning. We'll see how three important resources -- CPU, Memory and Disk -- play around these features.
You will learn:
- SQL Server 2017 features
- Internals of SQL Server
- SQL Server Automatic Tuning feature