Systems.Monitoring.WaitStats View
Namespace: Systems.Monitoring
Wait statistics dynamic management view. Entity: Dmv_Wait_Stats (Introduced in version 25.1.0.38)
Default Visualization
Default Display Text Format:
{Database}: {WaitCategory}
Default Search Members:
__
Category: DynamicViews
Show in UI: ShownByDefault
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| Database | string (64) | The database in which the wait operation is located. Required Filter(eq;like) ORD |
| MaxHoldLockTimeMs | double | Maximum time a lock was held, measured in milliseconds. Required |
| MaxWaitTimeMs | double | Maximum wait time for acquiring a lock, measured in milliseconds. . Required |
| StatisticsSince | datetime | The date and time since when the statistics are collected. Required Filter(ge;le) |
| TotalFailedAttempts | double | Indicates the total number of unsuccessful attempts to acquire locks. Required |
| TotalFailWaitTimeMs | double | Общо време на изчакване за неуспешни заключвания, измерено в милисекунди. Required |
| TotalHoldLockTimeMs | double | Indicates the total duration locks are held, measured in milliseconds. Required |
| TotalLocks | double | The total number of locks. Required |
| TotalSuccessWaitTimeMs | double | Indicates the cumulative time spent waiting for successful lock acquisitions, measured in milliseconds. Required |
| TotalWaitLocks | double | Indicates the total number of locks that have been acquired after waiting. Required |
| WaitCategory | string (128) | The category of the wait operation. Required |
Attribute Details
Database
The database in which the wait operation is located. Required Filter(eq;like) ORD
Type: string (64)
Category: System
Supported Filters: Equals, Like
Supports Order By: True
Maximum Length: 64
Show in UI: ShownByDefault
MaxHoldLockTimeMs
Maximum time a lock was held, measured in milliseconds. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
MaxWaitTimeMs
Maximum wait time for acquiring a lock, measured in milliseconds. . Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
StatisticsSince
The date and time since when the statistics are collected. Required Filter(ge;le)
Type: datetime
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
TotalFailedAttempts
Indicates the total number of unsuccessful attempts to acquire locks. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalFailWaitTimeMs
Общо време на изчакване за неуспешни заключвания, измерено в милисекунди. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalHoldLockTimeMs
Indicates the total duration locks are held, measured in milliseconds. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalLocks
The total number of locks. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalSuccessWaitTimeMs
Indicates the cumulative time spent waiting for successful lock acquisitions, measured in milliseconds. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalWaitLocks
Indicates the total number of locks that have been acquired after waiting. Required
Type: double
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitCategory
The category of the wait operation. Required
Type: string (128)
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Maximum Length: 128
Show in UI: ShownByDefault
API
Domain API Query: https://demodb.my.erp.net/api/domain/odata/Systems_Monitoring_WaitStats?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Systems_Monitoring_WaitStats?$top=10