September 21, 2016 at 4:48 am
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.
September 21, 2016 at 4:52 am
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
September 21, 2016 at 4:56 am
For both mdf and ldf disk ,64k works best?
September 22, 2016 at 1:41 am
Yes. Read the article I linked.
-- Gianluca Sartori
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply