TL;DR Is the RAID controller on the HP ProLiant DL360 G7 known to be slow or problematic? My RAID0 set is performing horribly.
I have an HP ProLiant DL360 G7. It came with a 160GiB SAS HDD, and I created a logical disk for it and set up Ubuntu Server on there. I inserted three consumer-grade SSDs (ADATA Premier SP550 960GB) that I knew worked with this server and created a RAID0 logical drive in ORCA including just the three SSDs. I then made the mistake of loading my entire 500GiB database on there, a long process, before I had run any benchmarks.
These SSDs are supposed to get 500GiB/s read... each. I've got 2 in RAID0 (using the Linux software RAID) on a consumer-level machine, and I see 1000GiB/s read with
hdparm -t. I'd think 3 in RAID0 on the server would get 1500GiB/s.
I get ~210MiB/s read on that SSD array, wow. Yes, I made sure to run the test with the database stopped and nothing else running. I've heard bad things about hardware RAID in the past. Is the RAID controller on this machine just slow? It'll be a big pain to migrate the DB, put each SSD into a separate logical disk, then set up the Linux software RAID, but I'm considering doing it.
Update: I've added a battery-backed-up disk cache module. Now seeing 648MiB/s with
hdparm, which I know isn't the best benchmark to use. So I tried running my actual workload on this machine, i.e. a process that repeatedly runs different heavy PostgreSQL queries concurrently, 24 at a time. I'm not seeing a disk bottleneck anymore. I suppose my problem is solved for now.