Cumulative waitstats per session - by WesleyB

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 275212 Comments
Status Closed Workarounds
Type Suggestion Repros 1
Opened 5/2/2007 1:29:21 AM
Access Restriction Public


Currently sys.dm_os_waiting_tasks gives the current wait stats of a session.  The problem with this is that wait information is very volatile and gets reset with every new 'wait'.  There is however no easy way of getting the total waittime per waittype for a session or a specific query.  
Sign in to post a comment.
Posted by WesleyB on 8/21/2007 at 11:43 AM
I will test it in the CTP.
Posted by Microsoft on 8/20/2007 at 10:36 AM
Hi Wesley,
Just wanted to update the thread with the latest information. This capability will be present in SQL 2008 by using the Extended Event feature by enabling the "wait_info" event.

Jerome Halmans
Program Manager SQLOS
Posted by Microsoft on 5/8/2007 at 10:46 AM
Thanks for your feedback. This is an issue that is being looked at for a future version of SQL Server.