SQL Server Performance

SQL 2005 NTFS Format / Block Size (Database)

Discussion in 'SQL Server 2005 Performance Tuning for Hardware' started by JHarper, May 22, 2007.

  1. JHarper New Member

    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.

  2. joechang New Member

    what standard 64K chunk write?

    default block size is fine,
    verify partition alignment, search diskpart or something like that
  3. satya Moderator

Share This Page