Cluster Size. Which the best?

Hi all,
Where can I find information about Cluster Size formating?
Which the best choice? (4k, 8k, 16k, 35k, 64k)
Is this depend of DB?
I mean, for only Select choice 8K, for insert 64k...'
Which the best solution?
What Microsoft say?
Thanks,
Daniel BarbosaSQL Server reads the data from the disk in 64K extents, so 64K is a natural
choice for the clustersize. IIRC, you can't defragment an NTFS volume if the
clustersize is larger than 4K, but if you use the disk only for SQL Server,
you can define the files to take up all the available disk space from the
start and you won't have any file fragmentation.
Jacco Schalkwijk
SQL Server MVP
"Daniel Barbosa" <anonymous@.discussions.microsoft.com> wrote in message
news:90C9861E-8ADB-450B-8494-9821C5865369@.microsoft.com...
> Hi all,
> Where can I find information about Cluster Size formating?
> Which the best choice? (4k, 8k, 16k, 35k, 64k)
> Is this depend of DB?
> I mean, for only Select choice 8K, for insert 64k...'
> Which the best solution?
> What Microsoft say?
> Thanks,
> Daniel Barbosa|||64kB or the size of eight 8kB SQL Server data pages is certainly best choice
for large reads but I am not sure that is the best cluster size for all sit
uations. As far I know the topic of the NTFS cluster size has never been inv
estigated maybe because dat
a page size is fixed.
NTFS volumes can be defragmented on Windows Server 2003 (and Windows XP) reg
ardless of the cluster size.
Sinisa Catic
Independent Consultant