AG node getting "misaligned log IOs which required falling back to synchronous IO" events in error log
1
vote
1
answer
1416
views
SQL 2016 AOAG. 3 node cluster. Primary and 1 secondary on-prem configured with synchronous availability mode. 1 node in Azure using asynchronous availability mode. We are using AOAGs to move data to the Azure node. The data and log drives on the Azure node were configured with 64k block size per best practices. Older on-prem nodes disk and log drives were configured with 512 blocks.
Soon after the Azure node was added to the AOAGs we started seeing multiple entries in the Azure SQL Error log like... "There have been ###### misaligned log IOs which required falling back to synchronous IO. The current IO is on file F:\mssql\Log\xxxxxxxxxxxxx_log.ldf. "
I now understand this is a result of the physical sector mismatch between the on-prem and Azure nodes (512 vs 64k)... We then followed the recommendations of enabling trace flag 1800 and expected those log entries to diminish. However, they have not.
log_send_queue_size and redo_queue_size values on the Azure node are very low.
Since the Azure node will eventually become the primary when applications are moved to Azure... Should we keep the 64k block size, or re-format and start over with AG synchronization ?
Asked by Ollie2308
(11 rep)
May 6, 2022, 07:04 PM
Last activity: Feb 13, 2025, 07:05 AM
Last activity: Feb 13, 2025, 07:05 AM