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. ...
© Tracy Boggiano and Grant Fritchey 2019
T. Boggiano, G. FritcheyQuery Store for SQL Server 2019https://doi.org/10.1007/978-1-4842-5004-4_66. Query Store Use Cases
Get Query Store for SQL Server 2019: Identify and Fix Poorly Performing Queries now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
