SQL Server Performance Investigation with MCP Workflows
Use DatabaseMCP to structure SQL Server performance investigations from alert to root cause, with clear paths for remediation.
Focus areas
- Top waits and contention patterns
- Slow batch and query plan analysis
- CPU, memory, and I/O bottlenecks
- Recurring regressions and historic trend checks