QuestionQ114

VerifiedMonitor, configure, and optimize database resources

You have an Azure SQL database called sqldb1.

You need to reduce the likelihood that Query Store transitions to a read-only state.

What should you do?

Explanation

Query Store checks its storage size when it flushes captured data to disk. A shorter Data Flush Interval performs these checks more often, reducing the chance that Query Store exceeds its maximum storage size between checks and transitions to read-only mode.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!