View Dmv_DB_Resource_Utilization

Entity

Entity: Systems.Monitoring.DBResourceUtilization

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. Entity: Dmv_DB_Resource_Utilization (Introduced in version 26.2.1.65)

Summary

Name	Type	Description
Avg_Cores_CPU	float	Normalized average CPU utilization by query executions in CPU-core units.
Avg_Cores_Total	float	Normalized average query execution duration in CPU-core units.
Avg_Cores_Waiting	float	Normalized average wait time for CPU/memory/IO/locks in CPU-core units.
Avg_Memory_per_Query_MB	float	Average memory used per executed query.
Avg_Query_Memory_Usage_MB	float	Average SQL Server memory usage attributable to query execution (query memory grant usage).
Disk_Read_MB	float	Total disk-read volume (MB) during the interval.
Disk_Read_Throughput_MBps	float	Average disk-read throughput (MB/s) during the interval.
Execution_Count	bigint	Total number of query executions during the interval.
Executions_per_Second	float	Average executions per second within the interval.
Interval_Completion_Ratio	float	Ratio (0–1) indicating how much of the interval has elapsed. Values < 1 mean the interval is still active and data is not final.
Runtime_Interval_Id	bigint	Identifier of the Query Store runtime interval (runtime_stats_interval_id).
Time_Slot_Begin_Utc	datetime	Start timestamp of the interval in UTC.
Time_Slot_End_Utc	datetime	End timestamp of the interval in UTC.
Total_Duration_ms	float	Total duration (ms) of all completed executions in the interval.
Total_Logical_Reads	bigint	Total logical reads executed during the interval.
Total_Logical_Writes	bigint	Total logical writes executed during the interval.
Total_Physical_Reads	bigint	Total physical reads executed during the interval.
Wait_CPU_ms	bigint	Total wait time due to CPU resource contention.
Wait_IO_ms	bigint	Total wait time related to IO operations.
Wait_Lock_ms	bigint	Total wait time caused by locks or blocking
Wait_Memory_ms	bigint	Total wait time due to memory resource contention.
Wait_Network_ms	bigint	Total wait time caused by network transfer-related waits.
Wait_Other_ms	bigint	Total wait time for all remaining wait categories.

Columns

Avg_Cores_CPU

Normalized average CPU utilization by query executions in CPU-core units.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Avg_Cores_Total

Normalized average query execution duration in CPU-core units.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Avg_Cores_Waiting

Normalized average wait time for CPU/memory/IO/locks in CPU-core units.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Avg_Memory_per_Query_MB

Average memory used per executed query.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Avg_Query_Memory_Usage_MB

Average SQL Server memory usage attributable to query execution (query memory grant usage).

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Disk_Read_MB

Total disk-read volume (MB) during the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Disk_Read_Throughput_MBps

Average disk-read throughput (MB/s) during the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Execution_Count

Total number of query executions during the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Executions_per_Second

Average executions per second within the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Interval_Completion_Ratio

Ratio (0–1) indicating how much of the interval has elapsed. Values < 1 mean the interval is still active and data is not final.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Interval_Completion_Ratio - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no

Runtime_Interval_Id

Identifier of the Query Store runtime interval (runtime_stats_interval_id).

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Runtime_Interval_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no
GreaterThanOrLessThan	None	no	no

Time_Slot_Begin_Utc

Start timestamp of the interval in UTC.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Time_Slot_Begin_Utc - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no
GreaterThanOrLessThan	None	no	no

Time_Slot_End_Utc

End timestamp of the interval in UTC.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	datetime
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Time_Slot_End_Utc - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
GreaterThanOrLessThan	None	no	no

Total_Duration_ms

Total duration (ms) of all completed executions in the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Logical_Reads

Total logical reads executed during the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Logical_Writes

Total logical writes executed during the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Physical_Reads

Total physical reads executed during the interval.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_CPU_ms

Total wait time due to CPU resource contention.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_IO_ms

Total wait time related to IO operations.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_Lock_ms

Total wait time caused by locks or blocking

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_Memory_ms

Total wait time due to memory resource contention.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_Network_ms

Total wait time caused by network transfer-related waits.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_Other_ms

Total wait time for all remaining wait categories.

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	bigint
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes