> ## 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.

# Avg Query Duration (ms), Microsoft SQL Server KPI card, Vortex IQ Nerve Centre

> total_elapsed_time / execution_count across sys.dm_exec_query_stats. p95/p99 not natively percentile - derived from per-query averages.

**[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:** Key Metrics
* **Chart:** kpi
* **Format:** number
* **Time window:** RT/5m
* **Alert trigger:** >200ms

## Calculation

total\_elapsed\_time / execution\_count across sys.dm\_exec\_query\_stats. p95/p99 not natively percentile - derived from per-query averages.

## Known limitations

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