Used Azure Migrate to migrate a SQL Server to Azure.
The on-premise SQL server has 2 disks (C: and E:) each having 512 bytes per sector and 512 bytes per Physical Sector settings.
Post migration the SQL Server C: disk now show 512 bytes per sector and 4096 bytes per Physical Sector settings and the E: (LOG) drive shows 512 bytes per sector and 512 bytes per physical sector.
This is causing SQL to throw errors misaligned log IOs.
Is there no way to deploy a disk to the SQL VM and set the sectors back to 512 bytes per physical sector?
Have already reviewed this: https://support.microsoft.com/en-us/topic/kb3009974-fix-slow-synchronization-when-disks-have-different-sector-sizes-for-primary-and-secondary-replica-log-files-in-sql-server-ag-and-logshipping-environments-ed181bf3-ce80-b6d0-f268-34135711043c