Does SQL Server 2017, including older versions, support 8k disk sector sizes?
15
votes
1
answer
1893
views
Disk (loosely worded to include not only rotational media but non-rotational media [SSD, NVMe, etc.]) drives are continuing to evolve in their underlying formats and hardware. Part of this was an "enhancement" from 512 byte physical sector sizes to 4k physical sector sizes, which changes the on disk layout (512n, 512e, 4kn).
This next evolution is in using 8k physical sector sizes, which some manufacturers are starting to produce and setup in production. Given this next step, is the 8k sector size disk supported in Windows? Does SQL Server care about sector sizes?
Asked by Sean Gallardy
(38305 rep)
Feb 28, 2019, 04:28 PM
Last activity: Mar 22, 2022, 01:53 PM
Last activity: Mar 22, 2022, 01:53 PM