View Dmv_Wait_Stats

Entity

Wait statistics dynamic management view. Entity: Dmv_Wait_Stats (Introduced in version 25.1.0.38)

Summary

Name	Type	Description
Database	`nvarchar(64)`	The database in which the wait operation is located
Max_Hold_Lock_Time_Ms	`float`	Maximum time a lock was held, measured in milliseconds.
Max_Wait_Time_Ms	`float`	Maximum wait time for acquiring a lock, measured in milliseconds.
Statistics_Since	`datetime`	The date and time since when the statistics are collected
Total_Fail_Wait_Time_Ms	`float`	Общо време на изчакване за неуспешни заключвания, измерено в милисекунди.
Total_Failed_Attempts	`float`	Indicates the total number of unsuccessful attempts to acquire locks.
Total_Hold_Lock_Time_Ms	`float`	Indicates the total duration locks are held, measured in milliseconds.
Total_Locks	`float`	The total number of locks.
Total_Success_Wait_Time_Ms	`float`	Indicates the cumulative time spent waiting for successful lock acquisitions, measured in milliseconds.
Total_Wait_Locks	`float`	Indicates the total number of locks that have been acquired after waiting.
Wait_Category	`nvarchar(128)`	The category of the wait operation.

Columns

Database

The database in which the wait operation is located

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

Max_Hold_Lock_Time_Ms

Maximum time a lock was held, measured in milliseconds.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Max_Wait_Time_Ms

Maximum wait time for acquiring a lock, measured in milliseconds.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

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_Fail_Wait_Time_Ms

Общо време на изчакване за неуспешни заключвания, измерено в милисекунди.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Failed_Attempts

Indicates the total number of unsuccessful attempts to acquire locks.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Hold_Lock_Time_Ms

Indicates the total duration locks are held, measured in milliseconds.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Locks

The total number of locks.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Success_Wait_Time_Ms

Indicates the cumulative time spent waiting for successful lock acquisitions, measured in milliseconds.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Total_Wait_Locks

Indicates the total number of locks that have been acquired after waiting.

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	no
Summary Type	None
Supports EQUALS_IN	no
Type	float
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Wait_Category

The category of the wait 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	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

Table of Contents