> ## Documentation Index
> Fetch the complete documentation index at: https://docs.vortexiq.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Missing-Index Recommendations, Microsoft SQL Server KPI card, Vortex IQ Nerve Centre

> SQL Server-distinctive - sys.dm_db_missing_index_details + group_stats. High avg_user_impact rows = index candidates.

**[Nerve Centre KPIs](/nerve-centre/kpi-cards/mssql) · [Audit Profile](/nerve-centre/kpi-cards/mssql/audit) · [Sentiment Settings](/nerve-centre/kpi-cards/mssql/sentiment)**

## At a glance

* **Category:** Performance
* **Type:** Supporting Metrics
* **Chart:** kpi
* **Format:** number
* **Time window:** RT/24h
* **Alert trigger:** >0 high-impact

## Calculation

SQL Server-distinctive - sys.dm\_db\_missing\_index\_details + group\_stats. High avg\_user\_impact rows = index candidates.

## Known limitations

*Known limitations, FAQs, or reconciliation notes specific to this card. Replace this block when authored.*