Verify Allocation Unit Size for SQL Server

,

Why Do I Care? Everything in SQL Server is stored on disk in 8K pages.  The Microsoft recommended best practice is to format using a 64K allocation unit size.  Processes such as the checkpoint and Lazy Writer try to write in extents when possible.  Extents are a collection of 8 pages and since each page […]

The post Verify Allocation Unit Size for SQL Server appeared first on Ryan Adams Blog.

Rate

Share

Share

Rate