December 9, 2015 at 11:43 pm
We have 2 node cluster which uses allocation unit 4k , do we need to change it to 64k?
what are the impact if we keep it 4k, by the way its an OLTP system.
December 12, 2015 at 10:45 pm
Anyone on this??
December 13, 2015 at 6:24 am
https://technet.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspx
http://dba.stackexchange.com/questions/28801/sql-server-ntfs-allocation-unit-size
Bear in mind that changing the size means repartitioning the drives, so that's a re-partition, re-format and reinstall. Downtime could be nasty.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
December 15, 2015 at 1:35 pm
GilaMonster (12/13/2015)
https://technet.microsoft.com/en-us/library/dd758814%28v=sql.100%29.aspxhttp://dba.stackexchange.com/questions/28801/sql-server-ntfs-allocation-unit-size
Bear in mind that changing the size means repartitioning the drives, so that's a re-partition, re-format and reinstall. Downtime could be nasty.
Thank a lot Gail. Think we have to take that heat and make the change .
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply