Partition Block Size

Partition Block Size

 

  


Hi Guys;
Cant seem to find any documentation on what OS block size works
best with SQL Server 2000 in an OLTP environment.

Also if the raid stripe size will have any impact on the IO.

Is 8K on SQL, OS and Strip size the best approach in an OLTP
environment;
Any experience here would be greatly appreciated;
Kind Regards
Willy


TREND MICRO EMAIL NOTICE
The information contained in this email and any attachments is confidential and may be subject to copyright or other intellectual property protection. If you are not the intended recipient, you are not authorized to use or disclose this information, and we request that you notify us by reply mail or telephone and delete the original message from your mail system.

MS Sql Server LazyDBA home page