Storage Performance
I'm just curious if anyone has done any storage tuning for performance. I have a few opinions on the issue but are just looking for what you think the configuration that would generate the best IO under heavy load.
Basically we have 1 MD3220 DAS that is connected through Fibre channel over copper to an MD1220. There are 24 disks per unit. We are running SQL server with tempdb/logs/backups/data. Consider the follow configurations:
A. Full 48 disk RAID 10
B. Split 24 disk RAID 10s on each shelf
C. Split 16/8 RAID 10s on each shelf (to split up the preferred service processor paths)
Try to ignore any thoughts about backups/tempdb needing to be on a different RAID for contention. We are planning on doing that. I assume you see we are discussing which would be the bottleneck... Spindles, Backplanes, Service Processors, or Fibre Channel between both units.
Basically we have 1 MD3220 DAS that is connected through Fibre channel over copper to an MD1220. There are 24 disks per unit. We are running SQL server with tempdb/logs/backups/data. Consider the follow configurations:
A. Full 48 disk RAID 10
B. Split 24 disk RAID 10s on each shelf
C. Split 16/8 RAID 10s on each shelf (to split up the preferred service processor paths)
Try to ignore any thoughts about backups/tempdb needing to be on a different RAID for contention. We are planning on doing that. I assume you see we are discussing which would be the bottleneck... Spindles, Backplanes, Service Processors, or Fibre Channel between both units.