Saturday, February 25, 2012

Page Size and Optimum Cluster Size

I would like to know the Page Size of SQL Server 2005.
If we implement SQL Server 2005 on SAN, what is the optimum size of the
cluster in NTFS format ? What is the relationship between the Page Size and
the cluster (Allocation Unit) size ?
Thanks"Jason" <Jason@.discussions.microsoft.com> wrote in
news:OmuTiWB8FHA.3388@.TK2MSFTNGP11.phx.gbl:
> If we implement SQL Server 2005 on SAN, what is the optimum size of
> the cluster in NTFS format ? What is the relationship between the
> Page Size and the cluster (Allocation Unit) size ?
On SQL Server 2000 the recommendation I've seen is 64k (One extent), and I
do think it is the same in SQL Server 2005.
One extent contains 8 pages. By using 64k allocation units, (in combination
with the same block size in the raid set/san) you have only one IO
operation on one single disk to read/write whole extent, thus reducing the
number of IOs when performing IO-intensive operations like a table scan.
--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging

No comments:

Post a Comment