Agentic slow SQL analysis via telemetry
Agentic slow SQL analysis via telemetry
An agent watches telemetry for slow SQL calls, finds the session and starts sampling. Its verdict identified an index issue with root causes and fixes.
Area: Developer tools. Status: GA. Developer relevance: high. Airtime: 3 min across 1 video, demoed.
Status evidence
- Nothing said about status; launch event convention: generally available unless stated otherwise.
Where they talk about it
- What's new: Agentic Developer Loop: 14:33 to 17:39, demo at 14:33 (called "Fully agentic slow-SQL analysis via telemetry (demo)" there)
Quotes
- 16:33 "it actually says another issue that there was an issue with the index because we were indexing by category code." - Shows the agent finding a concrete index problem, not only the slow statements.
Caveats mentioned
- Shown as a recorded run, not live, because it takes five minutes.
Prerequisites mentioned
- Telemetry tags for slow SQL calls
- Sampling profiling MCP server
Documented features match
- Profile slow Business Central sessions with AI agents - medium confidence (llm). Docs say: General availability, roadmap id 573335. Agent profiles slow session, summarizes SQL
Docs checked on 2026-10-02: the match is against Microsoft's what's new pages for the wave as they were on that date. Microsoft keeps filling the documentation, so "no documented item" can go stale. The wider product documentation on learn.microsoft.com was searched for this feature on the same date; the feature's data lists an article when one was found.
Tags: telemetry, profiling, sql, agents, performance
Generated by pipeline step 06. Source: YouTube auto-captions of the launch event videos, see the deep links. Not official.