Query Store is the answer to the challenges described previously. It was introduced in SQL Server 2016 and extended in SQL Server 2017. It collects the most relevant information about executed queries: query text, parameters, query optimization and compilation details, execution plans, execution statistics (execution time, CPU and memory usage, I/O execution details), and wait statistics; Query Store stores them in a database so that they are available after server restarts, failovers, or crashes.
You can use Query Store not only to identify performance issues, but also to fix some of them. Query Store offers a solution for issues caused by changed execution plans. By using Query Store, you can easily enforce an old plan; ...
