Microsoft SQL Server KPIs, Vortex IQ Nerve Centre

Nerve Centre KPIs · Audit Profile · Sentiment Settings Vortex IQ Nerve Centre tracks 31 KPI pulses for Microsoft SQL Server. Each metric has its own page: definition, calculation, why it matters, and what to do when it moves. The Microsoft SQL Server connector surfaces 31 KPI pulses in the Vortex IQ AI OS catalogue. Connect it once and every card below starts rendering automatically.

Card	Metrics type	Category	Chart
AG Secondary Lag (seconds)	Key Metrics	Replication	kpi
AG Secondary NOT SYNCHRONIZED / Lag >10s	Key Metrics	Nerve Centre	alert_list
Avg Query Duration (ms)	Key Metrics	Performance	kpi
Batch Requests / Second (live)	Key Metrics	Executive Overview	kpi
Blocked Sessions	Key Metrics	Concurrency	kpi
Blocking / Slow Queries During Checkout Window	Key Metrics	Cross-Channel: Revenue at Risk	table
Blocking Chain >30s	Key Metrics	Nerve Centre	alert_list
Buffer Cache Hit Ratio %	Key Metrics	Capacity	gauge
Connection Saturation %	Key Metrics	Capacity	gauge
Database Disk Usage %	Key Metrics	Executive Overview	gauge
Deadlocks (last 5m)	Key Metrics	Concurrency	kpi
Last Successful Backup (hours ago)	Key Metrics	Backup	kpi
Query Error Rate %	Key Metrics	Errors	gauge
Query Error Rate Spike (>1% in 5m)	Key Metrics	Nerve Centre	alert_list
SQL Connection Saturation vs Traffic Burst	Key Metrics	Cross-Channel: Revenue at Risk	table
SQL Load Spike vs Ecom Order Rate	Key Metrics	Cross-Channel: Revenue at Risk	dual_axis
SQL Product Table Row Count vs Ecom Catalog Size	Key Metrics	Cross-Channel: Revenue at Risk	kpi
SQL Server Health Score	Key Metrics	Executive Overview	gauge
Slow-Query Rate %	Key Metrics	Performance	gauge
TempDB Space Used %	Key Metrics	Capacity	gauge
Top Wait Types (signal vs resource)	Key Metrics	Performance	bar_horizontal
AG Redo Queue (KB)	Supporting Metrics	Replication	kpi
AG Replica Health (state)	Supporting Metrics	Replication	table
Active Sessions	Supporting Metrics	Capacity	kpi
Failed Logins (24h)	Supporting Metrics	Errors	kpi
Instance Uptime	Supporting Metrics	Executive Overview	kpi
Last Log Backup (minutes ago)	Supporting Metrics	Backup	kpi
Lock Waits / Second	Supporting Metrics	Concurrency	line
Missing-Index Recommendations	Supporting Metrics	Performance	kpi
Page Life Expectancy (sec)	Supporting Metrics	Capacity	kpi
Top 10 Slowest Queries	Supporting Metrics	Performance	table

Appendix space for FAQs, reconciliation guidance, or cross-connector notes specific to this connector. Replace this block when authored.

Top 10 Slowest Queries (digest), MariaDB

Audit

Get Started

The AI OS

Microsoft SQL Server KPIs, Vortex IQ Nerve Centre