Production would be Supermicro servers (8-16 CPU, 48/96/128GB RAM), with either banks of 10K RPM SATA drives, or a mix of SSD volumes and HDDs. All RAID-10. So

Production would be Supermicro servers (8-16 CPU, 48/96/128GB RAM), with either banks of 10K RPM SATA drives, or a mix of SSD volumes and HDDs. All RAID-10. Some servers are SSD only (< 8TB) that are used for current period (month / quarter) for add-hoc queries of actively changing data. The mixed configs use the SSD volumes for staging and ETL processing (aggregation for storage into fact tables), as well as frequently queried current period data. As data periods age, they are migrated to HDD volumes which hold more data at a lower price point. My budget does not yet support 20+ TB of all SSD storage.