Query Store in SQL Server 2016


In this episode of Data Exposed, Scott Welcomes Borko Novakovic, Program Manager in the SQL Server team. Borko joins Scott via Skype from his office in Belgrade, Serbia to introduce us to Query Store in SQL Server 2016, an awesome new technology which, among other things Borko explains, allows you to store the history of query plans in the system and capture the performance of each query over time. The Query Store also lets you look at and identify queries that have performed slower of time and make necessary adjustments. Borko shows us how easy it is to work with the Query Store and work with query plans.

If you troubleshoot query performance as part of your DBA responsibilities, then this show is a “much watch” for you!


Source link

, , , ,