July 15, 2013 at 1:15 am
Hello.
The average bytes/read is between 64k and 128k and the average bytes/write is between 32k and 64k.
What is the best, Raid 10 2+2 with stripe size 128k and cluster 64k or Raid 10 4+4 with stripe size 128k and cluster 32k?
Thanks.
July 15, 2013 at 8:19 am
msimone (7/15/2013)
Hello.The average bytes/read is between 64k and 128k and the average bytes/write is between 32k and 64k.
What is the best, Raid 10 2+2 with stripe size 128k and cluster 64k or Raid 10 4+4 with stripe size 128k and cluster 32k?
Thanks.
The more spindles the better.
You want to be using a stripe size of 64K or 256K, these are the optimal stripe sizes for SQL Server. Align the partition and then format the partition with 64K clusters and not the default 4K offered by Windows.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 16, 2013 at 1:41 am
Thank you very much.
July 16, 2013 at 3:49 am
you're welcome
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply