Create a monitoring and notification mechanism for HADR worker thread Pool

A customer approached us asking for help on automatic a monitoring process. The goal was to send some type of notification when a particular threshold was reached. He had already discovered this blog but still needed some guidance on how to get notified. Monitoring SQL Server 2012 AlwaysOn Availability Groups Worker Thread Consumption We created…

0

DBMIRROR_DBM_MUTEX: The world of Redo Operations

There are times when you just run into something and you can deem less important and continue. And there are times, where you have to stop and deal with it. In the past few weeks this wait type has simply come up way too many times. First, there is a great empirical blog post by Joe…

0

DbMgrPartnerCommitPolicy::SetSyncState May Seem More Mysterious than It Actually Is

AlwaysOn has become a major SQL Server technology. In my own process of learning it, I have often wondered what this mysterious message means. DbMgrPartnerCommitPolicy::SetSyncState: 00000026BD96D330:4 Decoding it may help others out there settle the fear of the unknown. 1. This message indicates the Synchronization state of an AlwaysOn partner: thus the ”  DbMgrPartnerCommitPolicy::SetSyncState” 2. The…

0