What is the purpose of the Query Store feature in Flexible Server?
- A To cache query results
- B To persist query runtime statistics and plans for performance analysis (correct answer)
- C To replicate queries to a replica
- D To encrypt queries
Shortcut: Query Store captures per-query runtime statistics and wait events into the azure_sys database, which is the primary tool for identifying regressions and top resource consumers.