Skip to main content

Home/ SQL Server/ Contents contributed and discussions participated by Phil Streiff

Contents contributed and discussions participated by Phil Streiff

Simple Middle Filter: All | Bookmarks | Topics
Phil Streiff

Disk Partition Alignment Best Practices for SQL Server - 1 views

msdn.microsoft.com/...dd758814.aspx

shared by Phil Streiff on 17 May 10 - Cached
  • Windows Server 2008 attempts to align new partitions out-of-the-box, yet disk partition alignment remains a relevant technology for partitions created on prior versions of Windows.
  • A sector is the minimum chunk of data that can be read or written to a hard drive. Historically, sector size has been fixed at 512 bytes.
  • Newer drives may offer 1 KB, 2 KB, or 4 KB sectors.
  • ...2 more annotations...
  • Bytes Per Cluster :               65536
  • The Bytes Per Cluster value, which contains the file allocation unit size, is highlighted here
1 - 1 of 1
Showing 20▼ items per page