Regressed queries

The Regressed queries report page shows queries with regressed performance over time. Query Store analyzes database workload and extracts the 25 most regressed queries according to the chosen metrics. You can choose between the following metrics: CPU time, Duration, Logical reads, Logical writes, Physical reads, Memory consumption, CLR time, DOP, and Row Count. You can also decide whether you want to see total numbers or maybe average, max, min, or standard deviation of the value chosen in the first step. The following screenshot shows regressed queries in a moderate database in a chart format:

View regressed queries in a ...

Get SQL Server 2017 Developer's Guide 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.