The Query Store is a feature that was introduced in SQL Server 2016, which 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 Chapter20. This can ...
