The Query Store captures the history of queries, their plans, and statistics. It allows DBAs to easily view the plans that were used by queries and troubleshoot performance issues. In this chapter, we will discuss how Query Store can be enabled and configured. We will also examine how the Query Store can be used to diagnose and resolve performance issues.
Enabling and Configuring Query Store
Query Store is enabled and configured at the database level, so the first thing we will do is create a database, called Chapter22 ...
