Description of SE_REPL Waits for Windows Azure SQL Database

  • Article

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.