New SQL Server 2016 Feature: "Query Store"
Track: Enterprise Database Administration & Deployment
Do you have any SQL Server monitoring tool in your production environment?
If so, what would you do when you find a trouble-making query?
Do you write a request to software developers to tune it?
In SQL Server 2016 you have an option not only monitor worst performing queries, but also decide how they have to be executed in your system. You can look at different query plans and force SQL Server to use the quickest one or one which uses less memory or IO.
During that session we will go through major new features of SQL Server 2016 and nail down the "Query Store".
You will learn about that new SQL Server feature and maybe you find how it would help you in your current production environment.