Hi thanks for your answer. Here are some precision, based on your question. In fact, I was more after the maximum performance our DMX may deliver, assuming the best scenario..
What other workloads are on the drives? Let's assume none. The box is almost empty.
What RAID5 (3+1 or 7+1)? 7+1
How many members in the meta? (I think maybe 4 from your post) META4
Are the meta members sharing the same physicals? You mean physical drives? No. It is a Striped Meta.
Is the workload sequential or random? It should be random. It is the DB volume of a MsSQL server. Logs are on another independant volume.
IO size? These look to be about 128KB IOs. This is a good one. NTFS5 is default to 4KB cluster size, MsSQL2005 is default to 8k pages and the read ahead is 64k.
But we are not sure for the application itself, how it organise the info but we may assume something even bigger.
So you have 32 drives doing large block random read IO with no writes.
This should not be a Symm limited, given enough front end ports, but limited by the drives. We have seen about 200MB/sec with random large block IOs from a single 7RAID5 group, and you have 4 of those, so your 50MB/sec seems well within the comfort zone.
And one other point... That number was at the limit, without regard for reasonable response times. In most cases, we tell folks to target somewhere around 50% of maximum to have reasonable response times.
Yes you are absolutly right. For MsSQL, Microsoft also recommends to try not go over 50-60% of the IO/sec capacity of the drives, to keep the counters Average Disk Sec/Read and Write below 10-12 ms.
Quincy561
1.3K Posts
0
January 30th, 2009 12:00
In this case, what it depends on is several things.
What other workloads are on the drives?
What RAID5 (3+1 or 7+1)?
How many members in the meta? (I think maybe 4 from your post)
Are the meta members sharing the same physicals?
Is the workload sequential or random?
IO size? These look to be about 128KB IOs.
The throughput of a single disk is dependant on some of these parameters, so I can't answer that either, except to say "It depends"
xe2sdc
4 Operator
•
2.8K Posts
0
February 2nd, 2009 06:00
As always when it comes to performances ..
nicoroy123_15c2b9
41 Posts
0
February 25th, 2009 08:00
Here are some precision, based on your question. In fact, I was more after the maximum performance our DMX may deliver, assuming the best scenario..
What other workloads are on the drives?
Let's assume none. The box is almost empty.
What RAID5 (3+1 or 7+1)?
7+1
How many members in the meta? (I think maybe 4 from your post)
META4
Are the meta members sharing the same physicals?
You mean physical drives? No. It is a Striped Meta.
Is the workload sequential or random?
It should be random. It is the DB volume of a MsSQL server. Logs are on another independant volume.
IO size? These look to be about 128KB IOs.
This is a good one. NTFS5 is default to 4KB cluster size, MsSQL2005 is default to 8k pages and the read ahead is 64k.
But we are not sure for the application itself, how it organise the info but we may assume something even bigger.
I hope it helps!
Thanks in advance.
nicoroy123_15c2b9
41 Posts
0
February 25th, 2009 09:00
nicoroy123_15c2b9
41 Posts
0
February 25th, 2009 09:00
Cool, now I have a number to work with.
Thank you very much!
Quincy561
1.3K Posts
0
February 25th, 2009 09:00
This should not be a Symm limited, given enough front end ports, but limited by the drives. We have seen about 200MB/sec with random large block IOs from a single 7RAID5 group, and you have 4 of those, so your 50MB/sec seems well within the comfort zone.
Quincy561
1.3K Posts
0
February 25th, 2009 09:00
Quincy561
1.3K Posts
0
February 25th, 2009 09:00
nicoroy123_15c2b9
41 Posts
0
February 26th, 2009 08:00