• Article Topics

  • Become a member of the SQLDBASupport community and receive notifications of new posts by email

    Join 82 other followers

  • Are you writer? Become an Author! Mail to

    amitvaid81 @ gmail dot com

  • Founder

    This is journey of a SQL DBA. I now work as a Sr. Database Architect and Solution Consultant, generally in performance tuning, clustering or high availability. The opinions expressed herein are my own personal opinions through real time experience.

    Amit Vaid

File Allocation Unit Size – A Myth

The overall meaning of “Allocation Unit Size” in brief is….

The default allocation unit size on a windows drive is 4KB. When we format the drive, we can set that to a larger size – again 64KB is recommended for SQL Server data, log, and tempdb files.
The allocation unit size is basically the smallest unit of storage that any individual file can take up. If I set the allocation unit size on a drive to 64KB and then create a tiny text file which only takes up 11 bytes, that one file will take up 64KB on disk.

Continue reading


SQL Server Architecture

This page has moved here