Question

You manage an Azure SQL Database and enabled Query Store weeks ago to analyze workload performance. When you open the Query Store reports today, you notice no new query data has been captured for the past several days, although the database is actively serving queries. Historical data from earlier is still visible. Which condition most likely explains why Query Store has stopped capturing new data?

Accepted Answer

The Query Store operation mode has transitioned to READ_ONLY because it reached its maximum allocated storage size.

Answer

Automatic tuning was disabled, which prevents Query Store from recording any runtime statistics.

Answer

The database compatibility level was lowered, automatically clearing the Query Store capture buffer.

Answer

The MAX_PLANS_PER_QUERY limit was reached, stopping all new query text from being stored.