After a Windows cluster briefly lost quorum, a client’s AlwaysOn queries got stuck waiting for HADR_AR_CRITICAL_SECTION_ENTRY. Here is how we fixed the wait.
SQL SERVER – Cluster Resource ‘AGName’ of type ‘SQL Server Availability Group’ in Clustered Role ‘AGName’ Failed
Configuring an availability group is easy; trouble starts when the cluster breaks. Here I fix a failed cluster resource of type SQL Server Availability Group.
SQL SERVER – Always On Availability Groups and Full-Text Index
Read queries were blocked on a secondary replica. Here is a common issue you may face when you use full-text index with Always On Availability Groups.
SQL SERVER – Unable to Create Always On Listener – Attempt to Locate a Writeable Domain Controller (in Domain Unspecified Domain) Failed
Can’t create an Always On listener? On three clusters, Event ID 1212 said the attempt to locate a writeable domain controller failed. I walk you through the fix.
SQL SERVER – Always On Secondary Replica Huge Redo Queue – Version Store is Full. New Version(s) Could Not be Added
The redo queue kept growing on an Always On secondary replica, and the ERRORLOG said version store is full. Here is what I found and why it happened.
SQL SERVER – Always On AG – HADRAG: Did not Find the Instance to Connect in SqlInstToNodeMap Key
After unexpected failovers, an availability group would not come online: Did not find the instance to connect in SqlInstToNodeMap key. This is how we solved it.
SQL SERVER – How to Fix log_reuse_wait_desc – AVAILABILITY_REPLICA?
A client’s database always showed AVAILABILITY_REPLICA in log_reuse_wait_desc of sys.databases. After quick research, here is what it means and how to fix it.