SQLTeam.com | Weblogs | Forums

What % of your waits are HADR_SYNC_COMMIT?

#1

For those of you using AGs or BAGs, what percentage of your total wait is HADR_SYNC_COMMIT?

For me it is 33% which seems high. Our database is both transactional and reporting. I would suspect that the waits would be higher for transactional.

Thanks.

0 Likes

#2

That seems very high to me. Mine is much, much lower on the transaction system.

0 Likes

#3

super high. might be time to separate olap from oltp. but worth investigating fully using in depth
forensics

0 Likes