Storage Performance

Mishra

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.

Mishra

Figure I'll try 1 bump.