Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
 Posted - 2009-05-29 : 16:54:57
|
| For any sql server i am seeing that the normal default for C: Drive that comes with the windows o/s 2005/2008 etc...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 .On the SAN EMC you can do this .Any ideas ...if the windows os at 4 kb is going to be slower regardless if your DISK/LOGS/TEMP are on SAN at 64 kb.Cheers |
|
|
|
|
|
disk formats