get_optimization_insights
Analyze SQL Server database health and optimization insights, identifying missing indexes and query performance issues to improve efficiency.
Instructions
Get comprehensive database optimization insights and health analysis
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | No | Database name (optional) | |
| analysis_period | No | Analysis time period: 24_HOURS, 7_DAYS, 30_DAYS (optional). RESERVED: accepted but not yet applied. The two DMV sources have different lifetimes and cannot be windowed consistently: missing-index aggregates are cumulative (reset only by a server restart or index/database changes) while query-stats rows last only while their plan stays in cache, so results reflect the lifetime of each source regardless of the value sent; the response discloses this in its analysisPeriod field. |