SQL Server misaligned log IOs which required falling back to synchronous IO

There have been 27888384 misaligned log IOs which required falling back to synchronous IO.
某一次在Production換新機後,突然Secondary狂噴如標題的Error。
Google後發現可能是Disk sector不Align的問題。

使用下列語法查詢Disk的狀態。

fsutil fsinfo ntfsinfo
繼續閱讀 “SQL Server misaligned log IOs which required falling back to synchronous IO"