mssql_performance_health
Analyze wait statistics, memory counters, and workload metrics to identify performance bottlenecks and receive rule-based optimization recommendations for SQL Server.
Instructions
Overall performance health check: top wait statistics (with benign waits filtered out), memory counters (Page Life Expectancy, memory grants pending, total vs target memory), workload counters (batch requests, compilations), and rule-based optimization recommendations (e.g. high CXPACKET → review MAXDOP, PAGEIOLATCH → check I/O and indexes, LCK_M → run mssql_find_blocking).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| response_format | No | Response format (default: markdown) | markdown |