Raid 10 query
- Thread starter SSuhaib
- Start date
TomBascom
Curmudgeon
The key piece of information needed to make such a recommendation is the workload. In particular the peak number of IO ops that you expect to see and the response time SLA (don't forget unusual, but critical, events like year end reporting, restoring and rolling forward, rebuilding indexes or dumping and loading....). Without that information we'd just be guessing.
Assuming that this is a live system -- if you do not have that information you need to gather it.
If the system is not yet live then you need to somehow estimate the workload. Then, once you are live, compare your estimate to reality and determine if changes are needed. (You will have a much stronger case if you take this approach -- management will see that you are not just pulling numbers out of thin air...)
The number of IO ops is also sensitive to tuning. If your system has not been well tuned then you probably have significant opportunities to greatly reduce to IO profile.
Assuming that this is a live system -- if you do not have that information you need to gather it.
If the system is not yet live then you need to somehow estimate the workload. Then, once you are live, compare your estimate to reality and determine if changes are needed. (You will have a much stronger case if you take this approach -- management will see that you are not just pulling numbers out of thin air...)
The number of IO ops is also sensitive to tuning. If your system has not been well tuned then you probably have significant opportunities to greatly reduce to IO profile.
Thanks Tom. I enquired about the IOs during peak hours and it is roughly between 80 & 100 IO/sec.
I just need a rough estimate of minimum disks we should club for the above environment whithout casuing any performance issues. I read in a 'whitepaper' some wherre that says 10 disk will give thorough output. Kindly share your thoughts on this issue.
I just need a rough estimate of minimum disks we should club for the above environment whithout casuing any performance issues. I read in a 'whitepaper' some wherre that says 10 disk will give thorough output. Kindly share your thoughts on this issue.
TomBascom
Curmudgeon
80 to 100 IO ops/sec is a pretty light load. That's probably your peak OLTP load rather than your peak "unusual but critical event" load.
It's also the sort of thing that 1 or 2 disks can easily handle. But, as I said, I doubt that that is your real peak load. So I would ask for at least 6 disks (effectively a stripe set of 3).
I would also be very seriously considering a mirrored pair of SSDs as an excellent alternative. It might even be cheaper and it would definitely be faster.
It's also the sort of thing that 1 or 2 disks can easily handle. But, as I said, I doubt that that is your real peak load. So I would ask for at least 6 disks (effectively a stripe set of 3).
I would also be very seriously considering a mirrored pair of SSDs as an excellent alternative. It might even be cheaper and it would definitely be faster.