15 new wait_types in RC0 build

As the builds progress we have gotten more and more wait_types

These where the number of wait_types in each version so far

  • 202 SQL Server 2005
  • 484 SQL Server 2008
  • 490 SQL Server 2008 R2
  • 631 CTP3
  • 646 RC0 (15 more as listed below)

These 15 are the ones I have not encountered before in any pre 2012 RCO builds - What are they ??

[Sorry] For now I just can't tell you as I simply do not have the resources to fully explain their purpose { Some of their purpose can be deduced by its name }

and none of these as yet show me any values other than 0 (zero)


Select *

from sys.dm_os_wait_stats

WHERE Wait_type in





As I learn more and try out the AlwaysON feature I’m sure some of these may start to show some numbers

Published Thursday, February 9, 2012 9:02 PM by NeilHambly
Filed under:


No Comments