December 18, 2001 at 3:09 pm
What is the recommened cluster size for NTFS5 Windows 2000 running SQL Server 2000?
I have heard to leave it at the default 4KB, and also to set it to the 64KB and was wondering if either is better since SQL 2000 now uses 8KB per page.
Thanks,
Scooter McFly
December 18, 2001 at 4:09 pm
Scooter, a really interesting question and one I will have to do some followup on.
I checked Inside SQL Server 2000, no mention.
Checking BOL and Technet also turned up nothing, same with SQL 2000 Operations guide.
I checked the SQL Server 2000 Optimization guide and there is lots of info (over 12 pages) on disk optimizations, but nothing on cluster size.
Since most read-ahead manager xfers are 64kb, this might help, but no empirical evidence.
I'll keep looking.
Steve Jones
December 18, 2001 at 4:43 pm
4k or larger should be ok. I try to use a 64k stripe on the raid sets. Even though SQL stores data in 8k pages, everything is a 64k read.
Andy
December 18, 2001 at 4:47 pm
December 19, 2001 at 5:03 am
Did a lot of testing when we got the FibreChannel. Not exhaustive by any means, but enough to see that smaller cluster sizes didnt work as well. Intel has a tool called IOMeter that will let you saturate the disks/controllers with IO to do good load testing.
Andy
December 19, 2001 at 5:52 am
Thanks for the replies, any help I can get on that subject would be great.
Scooter McFly
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply