Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SQL Server 2012 new wait types

الإجابة SQL Server 2012 new wait types

  • Wednesday, May 16, 2012 11:15 AM
     
     
    Sign In to Vote
    0

    Hey,
    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 : 
    http://technet.microsoft.com/en-us/library/ms179984.aspx )
    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,
    Thanks.

     

All Replies

  • Thursday, May 17, 2012 6:23 AM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi IRousso,

    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.

     


    Thanks,
    Maggie

     

    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
     
     
    Sign In to Vote
    0

    Hey,

    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..

    Thanks!

    Isaac.

    Isaac Rousso

     
  • Sunday, May 20, 2012 10:10 AM
     
     
    Sign In to Vote
    0

    Kindly check this link, it may help you.

    http://blog.sqlauthority.com/category/sql-wait-types/

     
  • Sunday, June 10, 2012 2:03 PM
     
     
    Sign In to Vote
    0

    Hey,

    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?

    Thanks!
    Isaac.

    Isaac Rousso