Table "Database Wait Statistics"
Virtual table that provides database wait statistics for performance monitoring and analysis.
Remarks
This table exposes database engine wait statistics that are crucial for diagnosing performance issues and understanding database workload patterns. Essential for database administrators and performance analysts to identify bottlenecks, resource contention, and optimization opportunities. The statistics are categorized by wait types and include timing information to help prioritize performance tuning efforts. Available in Cloud scope for database performance monitoring.
Properties
| Name | Value |
|---|---|
| DataPerCompany | False |
| Scope | Cloud |
Fields
| Name | Type | Description |
|---|---|---|
| "Wait Category" | Text[60] | The category or type of database wait being measured. |
| "Waiting Tasks Count" | BigInteger | The total number of tasks that have waited for this wait category. |
| "Wait Time in ms" | BigInteger | The total cumulative wait time for this category, measured in milliseconds. |
| "Max Wait Time in ms" | BigInteger | The maximum single wait time recorded for this category, measured in milliseconds. |
| "Signal Wait Time in ms" | BigInteger | The time spent in signal waits for this category, measured in milliseconds. |
| "Database start time" | DateTime | The timestamp when the database was started, providing context for the statistics collection period. |
| SystemId | Guid | |
| SystemCreatedAt | DateTime | |
| SystemCreatedBy | Guid | |
| SystemModifiedAt | DateTime | |
| SystemModifiedBy | Guid | |
| SystemRowVersion | BigInteger |