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

# Lock Waits / Second, Microsoft SQL Server KPI card, Vortex IQ Nerve Centre

> Lock Waits/sec from sys.dm_os_performance_counters. Climbing = contention building before deadlocks appear.

**[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:** Concurrency
* **Type:** Supporting Metrics
* **Chart:** line
* **Format:** number
* **Time window:** RT/15m
* **Alert trigger:** sustained spike >baseline

## Calculation

Lock Waits/sec from sys.dm\_os\_performance\_counters. Climbing = contention building before deadlocks appear.

## Known limitations

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