Found this recently in our environment:
whenever rebuild index job is running (with online or without), all the application connections are timing out and the wait types show as below
HADR_SYNC_COMMIT
found that this is a bug in Always on Availability groups when Synchronous mode is used.
To alleviate this, switch to Async mode, do your rebuild indexes and then switch back to Sync mode.
whenever rebuild index job is running (with online or without), all the application connections are timing out and the wait types show as below
HADR_SYNC_COMMIT
found that this is a bug in Always on Availability groups when Synchronous mode is used.
To alleviate this, switch to Async mode, do your rebuild indexes and then switch back to Sync mode.
Thanks for the post!
ReplyDelete