Table of Contents

Systems.Monitoring.ExecStats View

Namespace: Systems.Monitoring

Execution statistics dynamic management view. Entity: Dmv_Exec_Stats (Introduced in version 23.1.0.19)

Renames

Old name: Systems.Dmv.ExecStats
New name: Systems.Monitoring.ExecStats
Version: 24.1.5.35
Case: 35911

Default Visualization

Default Display Text Format:
{Application}: {Database}
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
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_Monitoring_ExecStats?$top=10

Domain API Query Builder: https://demodb.my.erp.net/api/domain/querybuilder#Systems_Monitoring_ExecStats?$top=10