Wait Type History
The metrics in this category report SQL Server wait statistics by wait type, measured as deltas since the previous collection, for wait-based performance analysis.
Evaluation and Collection Frequency — Every 30 Minutes
Table 2-84 Wait Type History Metrics
| Metric | Description |
|---|---|
|
Database Name (key column) |
Name of the database associated with the sampled wait statistics. |
|
Wait Type (key column) |
Name of the SQL Server wait type, as reported by |
|
Wait Time Delta (ms) |
Total wait time, in milliseconds, accumulated for this wait type since the previous collection (includes signal wait time). |
|
Waiting Tasks Delta |
Number of waits started for this wait type since the previous collection. |
|
Signal Wait Time Delta (ms) |
Difference, in milliseconds, between the time a waiting task was signaled and the time it started running, accumulated since the previous collection. |