8 x 15k SAS hdd disk with raid 0 performance vs single SSD disk for database [closed]

Solution 1:

You've given us almost zero information to work from here sorry, but let's make some assumptions and see where that gets us.

15K SAS disks are usually good for about 180-200MBps reading and writing sequential data, for random they're terrible and the SSD will win but let's stick with sequential. So 8 x 200MBps is 1.6GBps, which shouldn't flood a dual-12Gbps-SAS-bus HBA, nor will it flood the likely PCIe 3.0 x 8/16 lane bus it's connected to.

A single 12Gbps SSD is likely to be able to sustain that 12Gbps link, so think in the region of 1.4GBps of sequential performance.

So purely in terms of sequential access they're about the same, roughly anyway. But in terms of random operation the SSD will destroy the HDD's, by at least an order of magnitude.

Of course if you go with NVMe then the SSD wins both tests easily.