Posts
Labs and runbooks, newest first.
-
Replay: SQL Server Availability Group Synchronization State as You’ve Never Seen It
Replay four recorded runs of a six-replica distributed availability group and watch where the transaction log waits: a slow link, a slow disk, a blocked redo and a slow synchronous secondary.
-
Runbook: Serial vs Parallel Redo in SQL Server
80 redo tests on two four-node SQL Server labs in Azure: the backlog-drain method, the scripts, the real results, and why serial redo won hot-tail inserts on Ultra Disk.
-
Runbook: Local Time Zone in Azure SQL Database
A hands-on lab that tests every claim about the Local Time Zone preview in Azure SQL Database: scripts, real results, errors and recommendations.