Hi guys,
Today we have big problems with Availability Group (AG) synchronization.
Secondary cannot catch up with Primary.
It prevents Transaction Log Truncate to do the work.
Transaction Log has been growing from 160 GB to 200 GB since yesterday.
We noticed increate in Transaction/sec in SOLARWINDS.
CPU is starting to go up slowly in the last two days.
Now I start to think maybe the last time when performance problem occurred
AG slowness was the problem ? We just didn't know where to look?
On Secondary server
people reported error:
Executingthe query . . . . .
failed with the following error:"Database 'XXXXX' cannot be opened due to inaccessible files or insufficient memory or disk space.
There are a LOT of reasons why mirroring gets behind.
Note that if you don't do something about the tlog size (which is full of data) and you have an outage and need to restore it could take a VERY long time to recover the database, thus affecting your ability to meet your outage/recovery requirements.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service