Should 2048KB be added to NTFS block size in volumes that hold database files <> 64KB subsection?

microsoft / tigertoolbox

Toolbox repository for Tiger team

http://aka.ms/sqlserverteam

Other

1.48k stars 740 forks source link

Should 2048KB be added to NTFS block size in volumes that hold database files <> 64KB subsection? #211

Closed alexprotsenko closed 4 years ago

alexprotsenko commented 4 years ago

Hi @pmasl. Windows Server 2019 presents greater block sizes in comparison to the previous versions - up to 2048KB. Should the NTFS block size in volumes that hold database files <> 64KB subsection be updated to take this into account?

pmasl commented 4 years ago

Whether or not we should might be up for discussion at some time, but there aren't changes in the engine to warrant immediate reevaluation of the best practice you mention - the read-ahead logic is the same, driven by extents which are 64KB.

alexprotsenko commented 4 years ago

@pmasl, appreciate your fast response