May 29, 2009 at 7:54 pm
For any sql server i found the following information.
It is best to not use the default Block Size for Disks on Windows - The default block size in Windows is 4KB. That size might be fine for a file system—but not SQL Server data files. SQL Server writes are 8KB and read ahead is 64KB.
I recommend formatting the disks with 64KB. If applicable, perform a sector alignment of the disks in Windows before formatting them.
You could potentially see as much as a 20 percent performance gain.
Some disk subsystems don't need sector alignment, so check with your vendor's recommendations.
So the question is the actually SQL Server itself for C: that comes is there a way to make this 64KB .
and not be the 4kb .
On the SAN EMC you can do this .
Any ideas ...if the windows os C Disk can be formatted to 64 KB ...
Cheers
May 31, 2009 at 12:21 pm
The default block size actually changes depending upon the size of the volume.
Leave the OS disk as is. SQL data and log files are not (I hope) on here. 64k is ideal for the way that SQL writes, as you correctly mentioned. The operating system does not work the same way and the block size is optimized for disk usage versus performance.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply