Query Store. This is my choice in relation to “What feature release made you say WOW!”, the subject of this SQL Tuesday.
Query Store: The first release
Query Store was first released in SQL Server 2016, it’s getting closer to 10 years old, but we barely notice.
The starting idea was something simple, a common requirement and yet capable of making everyone say “WOW”.
Query tunning before query store was based on the current query activity, or the query plan cache.
If the query was not running at the moment of the analysis and it was also removed