SQL Server 2016: Query Store

Query Store is one of the new feature of SQL Server 2016. One of the great feature for troubleshooting performance problem. Almost 99% of the time, we the Database Administrator (DBA) get complaining email saying why the process that took 5 ms yesterday but now taking 5 min today. We the DBA had to do lots of work in order to answer that question and leave with some ambiguity. Look no further, configure Query Store this will definitely help you to solve issues within matter few mins. Query is running slow, find out query plan and see if there are multiple plan for the query then use the best query plan and force it with query store, yes it does work. Want to benchmark for 2-3 weeks for understanding the background, hey query store is great feature for it. I can go on and on about Query store. It is indeed a great feature. Can implement in database level very easily, do not like then can drop it very easily too without in any outage. SQL Server 2016 have lots of great feature.

courtesy of: https://docs.microsoft.com/en-us/sql/relational-databases/performance/how-query-store-collects-data