SQL Server 2016’s Query Store feature is, without a doubt, one of the most exciting new features for this version. The Query Store will keep track of current and past query execution plans which grants you deeper insights into the performance of your queries and allows you to pin a plan in-place, forcing the optimizer to continue to re-use that plan.
Brent Ozar has a great run down of the feature here.
Query Store, available in all editions
What is even more exciting than the feature itself is that it will be available in all editions. You may not believe me and I understand why. May 2nd has been a Monday ride on the emotional roller coaster of announcement oops’.
It all started when we thought Bob Ward implied Query Store would be in all editions.
Then Bob put us in our place.
As we all cried into our pillows under our desks, Bob returned to point out the facts. Apparently the data sheet on the general availability announcement was out-of-date.
That’s right fellow data nerds, books online confirms Query Store in all editions.