Analyzing the Query Store with an AI agent
Let Claude Code or Codex analyze the Query Store through sqlcmd, with a login that reads the Query Store but not the tables, or on a clone without data.
Categories:
21 minute read
Tag: Query Store
Query Store capture modes
What separates the ALL, AUTO, CUSTOM and NONE Query Store capture modes, with the AUTO thresholds measured on SQL Server 2019, 2022 and 2025.
Categories:
8 minute read
What the Query Store records
What the Query Store keeps about a query and what it leaves out: missing statements, interrupted executions, losses after a hard shutdown.
Categories:
8 minute read