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