SQLBits 2018

Man vs Machine: Adaptive query processing and auto tuning

Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL 2017. Adaptive query processing, auto tuning and few other features added into the product.

Query optimizer is getting smart, computers are taking DBAs jobs. In this session MVP Fabiano Amorim will talk about new “automatic” optimizations on SQL Server 2017. Adaptive query processing, auto tuning and few other features added into the product. Are you taking weekend off? What about turn automatic tuning on to avoid bad queries to show up after an index rebuild or an ‘unexpected’ change?

Speaker

Fabiano loves to conquer complex, challenging problems, especially the ones that others aren’t able to solve. Data Platform MVP since 2011, with over a decade of experience, he is well known in the DB community for his performance tuning skills.

Fabiano Neves Amorim's Sessions

Man vs Machine: Adaptive query processing and auto tuning