SQL Server and Windows on the same disk (allocation unit size 64kb-4kb)

%3CLINGO-SUB%20id%3D%22lingo-sub-3010794%22%20slang%3D%22en-US%22%3ESQL%20Server%20and%20Windows%20on%20the%20same%20disk%20(allocation%20unit%20size%2064kb-4kb)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3010794%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20running%20a%20server%20with%20SQL%20server%20with%202%20x%20960GB%20NVME%20Datacenter%20SSD%20in%20RAID1%2C%20windows%20files%20and%20database%20and%20default%20database%20files%20on%20the%20same%20disk.%3C%2FP%3E%3CP%3EThis%20server%20is%20using%20the%20default%20format%20allocation%20size%204Kb.%3C%2FP%3E%3CP%3EI%20have%20read%20that%2064Kb%20is%20better%20for%20SQL%20and%20this%20server%20is%20only%20hosting%20SQL%20server.%3C%2FP%3E%3CP%3EShould%20I%20reformat%20the%20server%20and%20reinstall%20Windows%202019%20server%20with%2064Kb%20allocation%20size%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3013218%22%20slang%3D%22en-US%22%3ERe%3A%20SQL%20Server%20and%20Windows%20on%20the%20same%20disk%20(allocation%20unit%20size%2064kb-4kb)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3013218%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1231262%22%20target%3D%22_blank%22%3E%40egyteam%3C%2FA%3E%26nbsp%3B%2C%20SQL%20Server%20use%20data%20pages%20%3D%208%20kbyte%2C%20it%20always%20reads%20%22Extents%22%20%3D%208%20page%20%3D%2064%20kbytes%20from%20disks%2C%20therefore%20it's%20always%20suggested%20to%20format%20disks%20for%20SQL%20Server%20data%20files%20in%20that%20size.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20in%20times%20of%20such%20fast%20SSD%20you%20won't%20notice%20a%20difference%2C%20so%20I%20wouldn't%20make%20efforts%20to%20reformat%20the%20disk.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Esee%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Frelational-databases%2Fpages-and-extents-architecture-guide%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3EPages%20and%20Extents%20Architecture%20Guide%20-%20SQL%20Server%20%7C%20Microsoft%20Docs%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 format allocation size 4Kb.

I have read that 64Kb is better for SQL and this server is only hosting SQL server.

Should I reformat the server and reinstall Windows 2019 server with 64Kb allocation size ?

 

Thank you!

1 Reply

@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