Systems.Dmv.ExecStats View
Namespace: Systems.Dmv
Execution statistics dynamic management view. Entity: Dmv_Exec_Stats (Introduced in version 23.1.0.19)
Default Visualization
Default Display Text Format:
{Application}: {Database}
Default Search Members:
__
Category: Views
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 |
|---|---|---|
| Application | string (64) | The name of the application that executes the operation. Required Filter(eq;like) ORD |
| AvgTimeMs | double | Average time of operation execution. Required Filter(ge;le) ORD |
| Count | int32 | The number of times the operation is executed since last statistics reset. Required Filter(ge;le) ORD |
| Database | string (64) | The database in which the operation is executed. Required Filter(eq;like) ORD |
| IsLongPolling | boolean | True if the operation is long polling. Required Filter(eq) |
| Kind | string (64) | The operation kind. Various operation kinds exist, e.g. Db, Long Procs etc. Required Filter(eq;like) ORD |
| MaxTimeMs | double | The maximum time of one operation execution. Required Filter(ge;le) ORD |
| Operation | string (128) | The operation name. Required Filter(like) |
| StatisticsSince | datetime | The date and time since when the statistics are collected. Required Filter(ge;le) |
| TotalTimeMs | double | Total time spent for the operation. Required Filter(ge;le) ORD |
Attribute Details
Application
The name of the application that executes the operation. 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
AvgTimeMs
Average time of operation execution. Required Filter(ge;le) ORD
Type: double
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
Count
The number of times the operation is executed since last statistics reset. Required Filter(ge;le) ORD
Type: int32
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
Database
The database in which the operation is executed. 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
IsLongPolling
True if the operation is long polling. Required Filter(eq)
Type: boolean
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
Kind
The operation kind. Various operation kinds exist, e.g. Db, Long Procs etc. 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
MaxTimeMs
The maximum time of one operation execution. Required Filter(ge;le) ORD
Type: double
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
Operation
The operation name. Required Filter(like)
Type: string (128)
Category: System
Supported Filters: Like
Supports Order By: False
Maximum Length: 128
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
TotalTimeMs
Total time spent for the operation. Required Filter(ge;le) ORD
Type: double
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
API
Domain API Query: https://demodb.my.erp.net/api/domain/odata/Systems_Dmv_ExecStats?$top=10
Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Systems_Dmv_ExecStats?$top=10