3

Why are SQL Server pages 8KB?

view full story
linux-howto

http://serverfault.com – As far as I know, Windows itself uses (small) page sizes of 4KB on both x86 and x64 architectures, so what is the technical reason for choosing a page size of 8KB for SQL Server? Why is it a good page size? (or maybe it's just an inheritance from its Sybase lineage) My first thought would be something related to disk storage, but I'm not sure since I think NTFS has a default cluster size of 4KB also. (HowTos)