Query Store Use Cases

Abstract

Query Store has different use cases that it is useful for. This chapter will go into detail on those use cases. We will discuss how to determine what is a normal workload on your database using Query Store by looking at the reports or catalog views and viewing changes against that baseline. Baselining a database is an essential skill for any DBA, and Query Store is a tool you can use to provide you with a baseline for your database. Sometimes you will need to identify what happened during a previous window of time. As a DBA you also will have to troubleshoot poorly performing queries or queries that have regressed in performance, and Query Store gives you the data to be able to do that as well. Query Store can help you identify the top consuming queries so you can see how to improve performance on the SQL Server database. Query Store can be used to capture queries after an upgrade of SQL Server to a different version and change the compatibility mode on each database later and fix any regressed queries, stabilizing upgrades of your SQL Server databases. Finally, we will look at how Query Store is used to track ad-hoc workloads and improve their performance.