Systems.Monitoring.DBResourceUtilization (View)
Returns diagnostic execution metrics for database queries within a specific Query Store interval. Values are aggregated, normalized, and partially recalculated from Query Store views (query_store_runtime_stats_interval, query_store_runtime_stats, query_store_wait_stats). Useful for performance monitoring, workload analysis, and automated diagnostics.
General
Namespace: Systems.Monitoring
Repository: Systems.Monitoring.DBResourceUtilization
Introduced In Version: 26.2.1.65
API access: ReadOnly
Visualization
Display Format: {RuntimeIntervalId}: {TimeSlotBeginUtc}
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).Introduced in version 26.2.2.3 |
| AvgMemoryPerQueryMB | double nullable | Average memory (MB) used per query execution. Introduced in version 26.2.2.3 |
| AvgTotalCores | double nullable | Average total load, expressed in CPU cores (relative to 1 core).Introduced in version 26.2.2.3 |
| AvgTotalQueryMemoryMB | double nullable | Average total memory (MB) consumed by all concurrent query executions.Introduced in version 26.2.2.3 |
| AvgWaitingCores | double nullable | Average waiting load, expressed in CPU cores (relative to 1 core).Introduced in version 26.2.2.3 |
| DiskReadMBps | double nullable | Average disk read throughput (MB/s) during the interval.Introduced in version 26.2.2.3 |
| DiskReadTotalMB | double nullable | Total disk read volume (MB) during the interval.Introduced in version 26.2.2.3 |
| ExecutionCount | int64 nullable | Total number of executed queries during the interval. |
| ExecutionsPerSecond | double nullable | Average number of queries executed per second. Introduced in version 26.2.2.3 |
| 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. |
| IsIntervalComplete | boolean nullable | Indicates whether this is completed or still active interval.Filter(eq) Introduced in version 26.2.2.3 |
| RuntimeIntervalId | int64 nullable | Unique identifier of the runtime interval.Filter(eq;ge;le) ORD |
| TimeSlotBeginUtc | datetime | Start timestamp of the interval in UTC.Required Filter(eq;ge;le) ORD |
| TimeSlotEndUtc | datetime | End timestamp of the interval in UTC.Required Filter(ge;le) |
| TotalDurationMs | double nullable | Total duration (ms) of all completed query executions in the interval. Introduced in version 26.2.2.3 |
| TotalLogicalReads | int64 nullable | Total logical reads executed during the interval. |
| TotalLogicalWrites | int64 nullable | Total logical writes executed during the interval. |
| TotalPhysicalReads | int64 nullable | Total physical reads executed during the interval. |
| WaitCpuMs | int64 nullable | Total wait time (ms) due to CPU resource contention. Introduced in version 26.2.2.3 |
| WaitIoMs | int64 nullable | Total wait time (ms) related to I/O operations. Introduced in version 26.2.2.3 |
| WaitLockMs | int64 nullable | Total wait time (ms) caused by locks or blocking. Introduced in version 26.2.2.3 |
| WaitMemoryMs | int64 nullable | Total wait time (ms) due to memory resource contention. Introduced in version 26.2.2.3 |
| WaitNetworkMs | int64 nullable | Total wait time (ms) caused by network transfer-related waits. Introduced in version 26.2.2.3 |
| WaitOtherMs | int64 nullable | Total wait time (ms) for events other than CPU, I/O, Lock, Memory, or Network. Introduced in version 26.2.2.3 |
Attribute Details
AvgCpuCores
Average CPU execution load, expressed in CPU cores (relative to 1 core).Introduced in version 26.2.2.3
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
AvgMemoryPerQueryMB
Average memory (MB) used per query execution. Introduced in version 26.2.2.3
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).Introduced in version 26.2.2.3
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.Introduced in version 26.2.2.3
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).Introduced in version 26.2.2.3
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DiskReadMBps
Average disk read throughput (MB/s) during the interval.Introduced in version 26.2.2.3
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
DiskReadTotalMB
Total disk read volume (MB) during the interval.Introduced in version 26.2.2.3
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
ExecutionsPerSecond
Average number of queries executed per second. Introduced in version 26.2.2.3
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
IsIntervalComplete
Indicates whether this is completed or still active interval.Filter(eq) Introduced in version 26.2.2.3
Type: boolean nullable
Category: System
Supported Filters: Equals
Supports Order By: False
Show in UI: ShownByDefault
RuntimeIntervalId
Unique identifier of the runtime interval.Filter(eq;ge;le) ORD
Type: int64 nullable
Category: System
Supported Filters: Equals, GreaterThanOrLessThan
Supports Order By: True
Show in UI: ShownByDefault
TimeSlotBeginUtc
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
TimeSlotEndUtc
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
TotalDurationMs
Total duration (ms) of all completed query executions in the interval. Introduced in version 26.2.2.3
Type: double nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalLogicalReads
Total logical reads executed during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalLogicalWrites
Total logical writes executed during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
TotalPhysicalReads
Total physical reads executed during the interval.
Type: int64 nullable
Category: System
Supported Filters: NotFilterable
Supports Order By: False
Show in UI: ShownByDefault
WaitCpuMs
Total wait time (ms) due to CPU resource contention. Introduced in version 26.2.2.3
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. Introduced in version 26.2.2.3
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. Introduced in version 26.2.2.3
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. Introduced in version 26.2.2.3
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. Introduced in version 26.2.2.3
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. Introduced in version 26.2.2.3
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