Automatic seeding of availability database failed with an unrecoverable error: it showed on the secondary, then vanished. Here is what ERRORLOG said.
Automatic Seeding in Always On: List and Monitor It
Automatic seeding in Always On lets the primary send a database to a secondary without a manual backup and restore. Three read-only queries show which replicas use it, what happened before and how far a seeding run has come. It also covers why it fails and when to switch it off.
Last Known Actual Plan in SQL Server: Query Plan Stats
The last known actual plan is the plan of the most recent run of a cached query, with its real row counts. This post turns the feature on for one database, reads the plan with sys.dm_exec_query_plan_stats and compares estimated rows with actual rows.
Drop Failed for Availability Group: Failed to Destroy the WSFC Group (Error 41000 and 41081)
A drop failed for Availability Group message can describe a partial removal, where SQL Server and Windows clustering no longer agree. The tests here read the HADR state, show what errors 41000 and 41081 say and prove that SET ONLINE cannot open a database that sits in RESTORING.
SQL SERVER – Installation Error: System.ArgumentNullException – Value Cannot be Null
A client automating SQL Server installs saw random failures: System.ArgumentNullException, Value cannot be null. Here is what Detail.txt showed and the cause.
SQL SERVER – Reviewing Sleeping Sessions Before Terminating Any Session
An inactive or sleeping session may still be a useful pooled connection. A customer case prompted my earlier session-cleanup script.
SQL SERVER – Error: 9642 – An error occurred in a Service Broker/Database Mirroring transport connection endpoint
Error 9642 in the ERRORLOG: an error occurred in a Service Broker/Database Mirroring transport connection endpoint. Here is what caused it for my client.