64k is best for SQL especially the log files.

--------------------------
Sent from my BlackBerry Wireless Handheld


-----Original Message-----
From: William_Dalton <mssqldba-ezmlmshield-x59085183.[Email address protected]
To: LazyDBA Discussion <[Email address protected]
Sent: Thu Apr 27 07:00:10 2006
Subject: 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.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
The information contained in this electronic message is for the exclusive and confidential use of the addressee. Any other distribution, use, reproduction or alteration of the information contained in this electronic message, by the addressee or by any other recipient, without the prior written consent of the sender is strictly prohibited. If you have received this electronic message in error, please notify the sender.


MS Sql Server LazyDBA home page