#8699: SQL Server DBA Tools -> Instead of displaying wait type ID, display wait type name

SachinPrakash reported 2013-04-18T20:41:33Z · last modified 2013-04-30T18:22:04Z

Dev	ivangron
QA

Priority	Low
Complexity	Unknown

Component	DBA-T - SQL Server - Session Mngr
Version	13.0

For SQL Server, Go to DBA Tools -> Session Manager -> Sessions tab.

Notice that the wait type column always displays a number. Can we, instead, display the wait type name?

sys.dm_os_wait_stats - this view shows wait_type name

Reference article on wait statistics

All Comments (2) Change History

ivangron 2013-04-23T20:26:54Z

showing the wait time string. No need to extract from other tables as its stored in the sysprocesses catalog view under lastwaittype...

lastwaittype

nchar(32)

A string indicating the name of the last or current wait type.

tariqrahiman 2013-04-24T17:41:51Z

Verified in 13.0.0-3