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.
DBCC PAGE Alternative: Read Page Headers with T-SQL
The best DBCC PAGE alternative is the function sys.dm_db_page_info. This post builds a demo table, lists all of its pages with the allocation view, and compares one page with DBCC PAGE. It also explains the two modes and the page wait use.
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 – Azure Key Vault Deletion Error – Vault ‘ProdRecoveryVault’ Cannot be Deleted as There are Existing Resources Within the Vault
Not an Azure Key Vault after all: a Recovery Services vault that would not delete. The AzureRM script is retired, and soft delete waits 14 days.
How to Find Queries Using an Index From SQL Server Plan Cache? – Interview Question of the Week #195
Before I dropped an unused index, my client’s CEO wanted proof. Here is how to find queries using an index from the SQL Server plan cache.
SQL SERVER – How to Change Authentication Mode Using T-SQL Query
A software vendor shipped SQL Express with Windows-only login by mistake. Here is how to change the authentication mode to mixed mode with a T-SQL query.