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

('DTCPNTSYNC','HADR_CONNECTIVITY_INFO','HADR_FILESTREAM_FILE_CLOSE','HADR_SYNCHRONIZING_THROTTLE'

,'HADR_TIMER_TASK','PREEMPTIVE_HADR_LEASE_MECHANISM','PWAIT_EVENT_SESSION_INIT_MUTEX','PWAIT_REPLICA_ONLINE_INIT_MUTEX'

,'RESOURCE_GOVERNOR_IDLE','SCAN_CHAR_HASH_ARRAY_INITIALIZATION','SP_SERVER_DIAGNOSTICS_BUFFER_ACCESS'

,'WAIT_XTP_GUEST','WAIT_XTP_TASK_SHUTDOWN','WAIT_XTP_TRAN_COMMIT','XTPPROC_PARTITIONED_STACK_CREATE')

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

Published 09 February 2012 21:02 by NeilHambly
Filed under:

Comments

No Comments