An AlwaysOn drop availability group operation is waiting for the termination of any background task that was scheduled as part of a previous command. For example, there may be a background task that is transitioning availability databases to the primary role. The DROP AVAILABILITY GROUP DDL must wait for this background task to terminate in order to avoid race conditions. Information from Microsoft®
Waitopedia is a comprehensive resource of information about SQL Server waits.
The description shown below is the top answer as voted by the Spotlight community.
The charts are based on 2.1 TB of data collected from 4207 instances uploaded by 323 Spotlight users over an 8 week period.
PWAIT_HADR_POST_ONLINE_COMPLETED
Category: Other
SQL Server versions: 2012, 2014, 2016, 2017
What is PWAIT_HADR_POST_ONLINE_COMPLETED?
1 Answer
|
|
answered 3318 days ago
Spotlight Essentials
|
|
|
This wait has never occurred recently
PWAIT_HADR_POST_ONLINE_COMPLETED has not occurred recently on 4207 instances checked.