Forum Discussion
egyteam
Nov 27, 2021Copper Contributor
SQL Server and Windows on the same disk (allocation unit size 64kb-4kb)
Hello, I am running a server with SQL server with 2 x 960GB NVME Datacenter SSD in RAID1, windows files and database and default database files on the same disk. This server is using the default fo...
olafhelper
Nov 29, 2021Bronze Contributor
egyteam , SQL Server use data pages = 8 kbyte, it always reads "Extents" = 8 page = 64 kbytes from disks, therefore it's always suggested to format disks for SQL Server data files in that size.
But in times of such fast SSD you won't notice a difference, so I wouldn't make efforts to reformat the disk.
see Pages and Extents Architecture Guide - SQL Server | Microsoft Docs