Wednesday, March 7, 2012

Block Size on Hardware for SQL Server 2000 on Windows enterprise 2

Any idea of best block size for hardware for SQL server 2000 on windows
enterprise 2003 edition?
Thanks
- NT
>
> Any idea of best block size for hardware for SQL server 2000 on windows
> enterprise 2003 edition?
> Thanks
> --
> - NT
According to:
http://www.microsoft.com/technet/pro...n/instant.mspx
Select the Appropriate Allocation Unit Size (ALU)
"Consider matching the file system ALU to the block size of the application
you are using. If SQL Server is using a 4 KB block size, when you format a
file system on a new disk drive, launch Disk Administrator, create the
partition, commit the partition changes, select Format, and then set the
ALU to 4096 bytes. Matching the file system block sizes can improve the
efficiency of the disk transfers when you use the application. For more ALU
size options, use the format command from the command prompt versus the
Disk Administrator tool."
Hope this helps,
Eric Crdenas
Senior support professional
This posting is provided "AS IS" with no warranties, and confers no rights.

No comments:

Post a Comment