The best allocation unit size

• mah_j

  SSCrazy

  Points: 2931

  More actions

  September 21, 2016 at 4:48 am

  #329897

  Hi

  what is the best allocation unit size NTFS for OLTP ?

  For OLTP, where it's mostly writes,does performance degrade with 64k allocation unit size?

  8k is appropriate or 64K?

  We have san storage,and SQLServer 2014 on windows 2012R2.

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 21, 2016 at 4:52 am

  #1902111

  64 works best with every type of workload in SQL Server.

  See https://technet.microsoft.com/en-us/library/dd758814(v=sql.100).aspx

  -- Gianluca Sartori

• mah_j

  SSCrazy

  Points: 2931

  More actions

  September 21, 2016 at 4:56 am

  #1902115

  For both mdf and ldf disk ,64k works best?

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  September 22, 2016 at 1:41 am

  #1902352

  Yes. Read the article I linked.

  -- Gianluca Sartori