RE: Disk Alignment
  Home FAQ Contact Sign in
microsoft.public.sqlserver.setup only
 
Advanced search
POPULAR GROUPS

more...

 Up
RE: Disk Alignment         

Group: microsoft.public.sqlserver.setup · Group Profile
Author: Platypus
Date: Sep 9, 2008 22:37

Why not just do what (apparently Vista / Longhorn do) and use an offest of
1024.

Otherwise I think the latest version of the SQL 2005 BPA actually tells you
if your partitions aren't aligned.

Surely, this is better than all this math...

HTH

"John Barr" wrote:
> I recently read some information regarding aligning the Disk for use with SQL
> Server. Meaning, since SQL Server handles data in chunks of 64KB that the
> disk drive SQL Server writes to should be configured to work in 64KB chunks.
> The articles I am referring to are listed below, and I am wondering what
> other peoples thoughts are. I am also interested in understanding how to
> determine whether my disks are aligned and/or how to align them. Based on the
> articles, I see my Offset is 32KB on my drives, but I am also trying to work
> with the formula in the Microsoft KB article to determine how/where exactly I
> become aligned. The formula is:
>
> ((Partition offset) * (Disk sector size)) / (Stripe unit size)
>
> How do I determine these values???
>
> Here is the Microsoft article.
>
> http://support.microsoft.com/kb/929491
>
> Here is the other article.
>
> http://itknowledgeexchange.techtarget.com/sql-server/how-much-performance-are-you.../#comments
>
> Thanks in advance for your help.
>
no comments
diggit! del.icio.us! reddit!