Wednesday, May 16, 2012 11:15 AM
I'm looking into the new wait types in Sql Server 2012:
I've extracted a list of them (there are 197 new ones -
(by running: "select wait_type from sys.dm_os_wait_stats order by wait_type asc;")
and I'm wondering if a detailed documentation of the new wait types is available
(similar to what i found online for a previous version of Sql Server :
with a description of each wait type,
since i'm trying to figure out what exactly each of them means..
I'd appreciate your help,
Thursday, May 17, 2012 6:23 AMModerator
In SQL Server, Wait Types represent the steps where query waits for resources as the instance completes the request. There are hundreds of Wait Types in SQL 2005, more in 2008, and 169 new ones in SQL 2012.
You want to know SQL Server 2012 new wait types. I think the link you gave is OK.
Wait types in SQL Server 2012: http://msdn.microsoft.com/en-us/library/ms179984.aspx.
Please remember to mark the replies as answers if they help and unmark them if they provide no help. This can be beneficial to other community members reading the thread.
Sunday, May 20, 2012 7:40 AM
Thanks for your reply!
The link I gave was an example of what i'm looking for,
in that link the new wait types (169 as you mentioned) that were added to SQL-Server 2012 do not appear.
I was wondering if Microsoft has a new documentation page / are planing to release one
with the new wait types and their description soon..
Sunday, May 20, 2012 10:10 AM
Kindly check this link, it may help you.
Sunday, June 10, 2012 2:03 PM
thanks for the response.
This blog has allot of interesting information!, but what i really need is
a list of the new SQL Server 2012 wait types and a short explanation for each of them
similar to the table found on the official Microsoft documentation page (http://msdn.microsoft.com/en-us/library/ms179984.aspx)
where can i find such a page? any ideas?