[dba-SQLServer] Block size for SQL Server disk

Francisco Tapia fhtapia at gmail.com
Thu Aug 19 17:43:54 CDT 2004


On Thu, 19 Aug 2004 16:01:05 -0400, John W. Colby
<jwcolby at colbyconsulting.com> wrote:
> I have purchased new disks to build this new SQL Server database on.  I
> believe I have read that SQL Server uses 8k block sizes internally.  Is it
> useful to format the hard disk to 8K sectors so that the SQL blocks map to
> sectors directly?  Does anyone know if this helps or hinders?

Although Sql Server uses 8k block sizes internally I've never heard on
any list that it's a good idea to format your hdd that way... so I'd
say nope.

-- 
-Francisco



More information about the dba-SQLServer mailing list