Systems.Monitoring.DbResourceUtilization (View)
Provides aggregated metrics for database query execution within a given time interval. The data reflects system workload, including CPU usage, waiting time, memory consumption, and I/O activity. Useful for performance monitoring, workload analysis, and automated diagnostics. To retrieve the data for a period, there must be a filter over the Interval Start Utc field (suggested filter - greater than for no more than a day back).
General
Namespace: Systems.Monitoring
Repository: Systems.Monitoring.DbResourceUtilization
Introduced In Version: 26.2.2.11
API access: ReadWrite
Visualization
Display Format: {IntervalId}: {IntervalStartUtc}
Search Members:
Category: Views
Show in UI: HiddenByDefault
Aggregate
An aggregate is a cluster of domain objects that can be treated as a single unit.
Aggregate Tree
Attributes
| Name | Type | Description |
|---|---|---|
| AvgCpuCores | double nullable | Average CPU execution load, expressed in CPU cores (relative to 1 core). |
| AvgMemoryPerQueryMB | double nullable | Average memory (MB) used per query execution. |
| AvgTotalCores | double nullable | Average total load, expressed in CPU cores (relative to 1 core). |
| AvgTotalQueryMemoryMB | double nullable | Average total memory (MB) consumed by all concurrent query executions. |
| AvgWaitingCores | double nullable | Average waiting load, expressed in CPU cores (relative to 1 core). |
| ExecutionCount | int64 nullable | Total number of executed queries during the interval. |
| ExecutionDurationMs | double nullable | Total duration (ms) of all completed query executions in the interval. |
| ExecutionsPerSecond | double nullable | Average number of queries executed per second. |
| IntervalCompletionRatio | double nullable | Ratio (0–1) indicating how much of the interval has elapsed. Values < 1 mean the interval is still active and data is not final. |
| IntervalEndUtc | datetime | End timestamp of the interval in UTC.Required Filter(ge;le) |
| IntervalId | int64 nullable | Unique identifier of the runtime interval.Filter(eq) |
| IntervalIsCompleted | boolean nullable | Indicates whether this is completed or still active interval.Filter(eq) |
| IntervalStartUtc | datetime | Start timestamp of the interval in UTC.Required Filter(eq;ge;le) ORD |
| LogicalReads | int64 nullable | Total logical reads executed during the interval. |
| LogicalWrites | int64 nullable | Total logical writes executed during the interval. |
| PhysicalReadsCount | int64 nullable | Total physical reads executed during the interval. |
| PhysicalReadsMB | double nullable | Total disk read volume (MB) during the interval. |
| PhysicalReadsMBps | double nullable | Average disk read throughput (MB/s) during the interval. |
| WaitCpuMs | int64 nullable | Total wait time (ms) due to CPU resource contention. |
| WaitIoMs | int64 nullable | Total wait time (ms) related to I/O operations. |
| WaitLockMs | int64 nullable | Total wait time (ms) caused by locks or blocking. |
| WaitMemoryMs | int64 nullable | Total wait time (ms) due to memory resource contention. |
| WaitNetworkMs | int64 nullable | Total wait time (ms) caused by network transfer-related waits. |
| WaitOtherMs | int64 nullable | Total wait time (ms) for events other than CPU, I/O, Lock, Memory, or Network. |
Attribute Details
AvgCpuCores
Average CPU execution load, expressed in CPU cores (relative to 1 core).
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
AvgMemoryPerQueryMB
Average memory (MB) used per query execution.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
AvgTotalCores
Average total load, expressed in CPU cores (relative to 1 core).
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
AvgTotalQueryMemoryMB
Average total memory (MB) consumed by all concurrent query executions.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
AvgWaitingCores
Average waiting load, expressed in CPU cores (relative to 1 core).
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ExecutionCount
Total number of executed queries during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ExecutionDurationMs
Total duration (ms) of all completed query executions in the interval.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
ExecutionsPerSecond
Average number of queries executed per second.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
IntervalCompletionRatio
Ratio (0–1) indicating how much of the interval has elapsed. Values < 1 mean the interval is still active and data is not final.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
IntervalEndUtc
End timestamp of the interval in UTC.Required Filter(ge;le)
Type: datetime
Category: System
Supported Filters: GreaterThanOrLessThan
Supports Order By: False
Show in UI: ShownByDefault
IntervalId
Unique identifier of the runtime interval.Filter(eq)
Type: int64 nullable
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
IntervalIsCompleted
Indicates whether this is completed or still active interval.Filter(eq)
Type: boolean nullable
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
IntervalStartUtc
Start timestamp of the interval in UTC.Required Filter(eq;ge;le) ORD
Type: datetime
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
LogicalReads
Total logical reads executed during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
LogicalWrites
Total logical writes executed during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
PhysicalReadsCount
Total physical reads executed during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
PhysicalReadsMB
Total disk read volume (MB) during the interval.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
PhysicalReadsMBps
Average disk read throughput (MB/s) during the interval.
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitCpuMs
Total wait time (ms) due to CPU resource contention.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitIoMs
Total wait time (ms) related to I/O operations.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitLockMs
Total wait time (ms) caused by locks or blocking.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitMemoryMs
Total wait time (ms) due to memory resource contention.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitNetworkMs
Total wait time (ms) caused by network transfer-related waits.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitOtherMs
Total wait time (ms) for events other than CPU, I/O, Lock, Memory, or Network.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
API
Domain API Entity Set: Systems_Monitoring_DbResourceUtilization
Domain API Entity Type: Systems_Monitoring_DbResourceUtilizationEntry
Domain API Query: https://testdb.my.erp.net/api/domain/odata/Systems_Monitoring_DbResourceUtilization?$top=10
Domain API Query Builder: https://testdb.my.erp.net/api/domain/querybuilder#Systems_Monitoring_DbResourceUtilization?$top=10