SQL Server Performance Tuning and Optimization

SQH10 Adaptive Query Processing


2:30pm - 3:45pm

Level: Introductory to Intermediate

Hugo Kornelis


Database Consultant

PerFact B.V.

Late 2016, Microsoft announced a new feature coming to both SQL Database on Azure and SQL Server "vNext": Adaptive Query Processing.

What exactly does this mean, and what does it do? What are typical use cases, and where could this new feature cause issues? All those questions, and many more, will be answered in this session.

You will learn:

  • How to use cases of Adaptive Query Processing
  • The limitations of Adaptive Query Processing
  • How to recognize when Adaptive Query Processing is used