SQL Server Performance Forum – Threads Archive
SQL 2005 NTFS Format / Block Size (Database)Just for confirmation, has the standard 64K chunk write changed with SQL 2005 database writes or does it still remain the same? I’ve always used 4K for log partitions? Any constructive advice would be appreciated. Thanks!
what standard 64K chunk write? default block size is fine,
verify partition alignment, search diskpart or something like that
May behttp://download.microsoft.com/download/4/7/a/47a548b9-249e-484c-abd7-29f31282b04d/SQLIOBasicsCh2.doc too. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.