Description of SE_REPL Waits for Windows Azure SQL Database
Description of SE_REPL Waits for Windows Azure SQL Database
Chris Skorlinski and John Sims
Microsoft SQL Server Escalation Services
If you've missed the announcement, we just published description of the Windows Azure SQL Database waits types including the SE_REPL waits.
sys.dm_db_wait_stats
https://msdn.microsoft.com/en-us/library/dn170450.aspx
SE_REPL_CATCHUP_THROTTLE |
Occurs when the transaction is waiting for one of the database secondaries to make progress. |
SE_REPL_COMMIT_ACK |
Occurs when the transaction is waiting for quorum commit acknowledgement from secondary replicas. |
SE_REPL_COMMIT_TURN |
Occurs when the transaction is waiting for commit after receiving quorum commit acknowledgements. |
SE_REPL_ROLLBACK_ACK |
Occurs when the transaction is waiting for quorum rollback acknowledgement from secondary replicas. |
SE_REPL_SLOW_SECONDARY_THROTTLE |
Occurs when the thread is waiting for one of the database secondary replicas. |