View Dmv_Exec_Stats
Entity
Entity: Systems.Monitoring.ExecStats
Execution statistics dynamic management view. Entity: Dmv_Exec_Stats (Introduced in version 23.1.0.19)
Summary
| Name |
Type |
Description |
| Application |
nvarchar(64) |
The name of the application that executes the operation |
| Avg_Time_Ms |
float |
Average time of operation execution |
| Count |
int |
The number of times the operation is executed since last statistics reset. |
| Database |
nvarchar(64) |
The database in which the operation is executed |
| Is_Long_Polling |
bit |
True if the operation is long polling. |
| Kind |
nvarchar(64) |
The operation kind. Various operation kinds exist, e.g. Db, Long Procs etc. |
| Max_Time_Ms |
float |
The maximum time of one operation execution |
| Operation |
nvarchar(128) |
The operation name |
| Statistics_Since |
datetime |
The date and time since when the statistics are collected |
| Total_Time_Ms |
float |
Total time spent for the operation |
Columns
Application
The name of the application that executes the operation
| 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 |
64 |
| 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 |
nvarchar(64) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Application - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
| Like |
None |
no |
no |
Avg_Time_Ms
Average time of operation execution
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Format |
N0 |
| 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 |
float |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Avg_Time_Ms - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
no |
no |
Count
The number of times the operation is executed since last statistics reset.
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Format |
N0 |
| 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 |
int |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Count - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
no |
no |
Database
The database in which the operation is executed
| 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 |
64 |
| 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 |
nvarchar(64) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Database - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
| Like |
None |
no |
no |
Is_Long_Polling
True if the operation is long polling.
| 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 |
bit |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Is_Long_Polling - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
no |
Kind
The operation kind. Various operation kinds exist, e.g. Db, Long Procs etc.
| 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 |
64 |
| 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 |
nvarchar(64) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Kind - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Equals |
NULL |
no |
yes |
| Like |
None |
no |
no |
Max_Time_Ms
The maximum time of one operation execution
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Format |
N0 |
| 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 |
float |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Max_Time_Ms - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
no |
no |
Operation
The operation name
| 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 |
128 |
| 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 |
nvarchar(128) |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Operation - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| Like |
None |
no |
no |
Statistics_Since
The date and time since when the statistics are collected
| 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 |
Statistics_Since - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
no |
no |
Total_Time_Ms
Total time spent for the operation
| Property |
Value |
| Auto Complete |
no |
| Data Filter |
no |
| Default Value |
None |
| Enter Stop |
yes |
| Format |
N0 |
| 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 |
float |
| UI Memo Editor |
no |
| UI Width |
Medium |
| User Login |
no |
| Visible |
yes |
Total_Time_Ms - Supported Filters
| Filter Type |
Default |
Include Nulls |
Hidden by Default |
| GreaterThanOrLessThan |
None |
no |
no |