Query Store in SQL Server 2016

Zero to Hero with SQL Server https://goo.gl/rfNuru
Designing Database Solutions for SQL Server https://goo.gl/EMbg0c
MongoDb Tutorial for Beginners http://bit.ly/1ItFgDY

Big Data with the Microsoft Analytics Platform System

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!

If you feel useful for you and for everyone, please share it!

Source via: Channel9 - MVA

Subscribe: http://goo.gl/gA1NLZ
Facebook: http://goo.gl/oEk624
Group: http://goo.gl/xPdeEX
Google+: http://goo.gl/iGZzZX
Twitter: http://goo.gl/PNRtC8
About & Contact: http://goo.gl/JAolqj

code source