Anyone with experience of SQL Server performance tuning
It’s a work day, and you’re in front of your monitor battling a vicious query. You’ve already tuned a query or two in your life and have some tricks up your sleeve, but nothing seems to get this query down to a reasonable time and allow you to drink that cup of coffee you want so bad.
SQL Server 2016 adds a few impressive new features that might help you with that.
During the session, we will look at the different performance tuning aspects the new features enhance: Execution plan history and enforcement using the Query Store, live query execution visualization, DMV enhancements, new query hints, and more.
Join this session to see how SQL Server 2016 makes performance tuning easier and more efficient.
Why I Want to Present This Session:
I’ve been working with SQL Server for many years, and performance tuning is my bread and butter. The SQL Server 2016 new features will enhance my arsenal, and I believe anyone doing performance tuning work should know them.
Latest posts by Matan Yungman (see all)
- SQL Server 2016 Features for Performance Tuning Lovers - December 5, 2016