DAC_INIT

Description

This wait accumulates when a login starts the Dedicated Administrator Connection (DAC). This connection is reserved for sysadmin members in case the SQL Server instance becomes unresponsive. This wait type is uncommon

Resolved by

DBAs

Suggested solutions

  1. If this wait type is high use Profiler/trace/Extended Events to identify who is using the DAC connection. SQL Server only allows one login access through the DAC so make sure it is being used only when appropriate

Additional research

Diagnostic Connection for Database Administrators
Filtering Out Benign Waits

See more

Consider using ApexSQL Monitor, a Windows and SQL Server monitoring tool able to track SQL Server wait types, including the individual query wait statistics

⇐ Back to index