In this chapter, you have learned that Query Store is a great troubleshooting tool and captures all execution-relevant parameters for database queries: query details, execution plans, and runtime statistics and stores them in the same database so that they can survive after server failures. All that is done out-of-the-box, with minimal impact on the database workload.

By using Query Store, you can not only quickly identify performance regressions, but also mitigate them by forcing a well-known and previously used execution plan. Query Store will save you time and money. It also helps you to learn how your database workload changes over time and to identify queries that did not execute successfully.

With the automatic tuning feature, you can get a list of regressed queries with tuning actions recommended by Query Store, which significantly reduces troubleshooting time and even offers you fully automated tuning for queries with a regressed executed plan.

In the next chapter, you will discover the power of columnstore indexes and memory-optimized objects.