A full-text index can block the redo thread of a readable Always On secondary. This post shows the three clues to read in sys.dm_exec_requests, how to find the internal table and how to check change tracking. It ends with the fix: manual tracking and a scheduled population.
HADRAG Error: Did Not Find the Instance to Connect in SqlInstToNodeMap Key
The HADRAG error ‘Did not find the instance to connect in SqlInstToNodeMap key’ kept an Always On availability group offline after unexpected failovers. The cluster log pointed to a metadata mismatch. Dropping the group on the secondary and recreating it brought it back.
SQL SERVER – Microsoft Azure – Unable to Find Higher Tier Series Virtual Machine to Upgrade
My client wanted to upsize an Azure VM running Always On from D-Series to a higher tier G-Series size, but it was missing from the list. Here is what I suggested.
SQL SERVER – Database Mirroring Login Attempt Failed With Error: ‘Connection Handshake Failed. An OS Call Failed: (80090350)
Connection handshake failed with 0x80090350 on an availability group replica. What the code means, why it says mirroring, and what to check.
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLDB’ is Full Due to ‘DATABASE_MIRRORING’
Error 9002 has many causes. Here I explain the one where the transaction log for database ‘SQLDB’ is full due to ‘DATABASE_MIRRORING’ and what it tells you.
SQL SERVER – Slow SQL Server 2016 Installation in Cluster: RunRemoteDiscoveryAction
A client’s SQL Server 2016 Installation in Cluster hung at RunRemoteDiscoveryAction while setup ran discovery on the other node. Here is the cause of the delay.
SQL SERVER – Parallel Redo on AlwaysOn Secondary – DIRTY_PAGE_TABLE_LOCK
Redo lag and high DIRTY_PAGE_TABLE_LOCK waits hit a client’s AlwaysOn secondary. Here is how Parallel Redo in SQL Server 2016 causes them and what to do.