Query Store for Everyone

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.

brent announcement

Then Bob put us in our place.

bob wards announcement

Today the version release date (June 1st, 2016) was announced and the announcement had a link to the edition data sheet. The data sheet showed Query Store as only an Enterprise edition feature.

crying

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.

bob wards announcement2

That’s right fellow data nerds, books online confirms Query Store in all editions.

querystoreeditions

Leave a Reply

%d bloggers like this: