As luck would have it I can't find my notes from a conference session where the topic of SSD was discussed.
If I recall it was mentioned that running the Tessitura production database on an all SSD array would be optimal. However, I was hoping to find some documentation that gave more information on the optimal i/o metrics for the live database, log files, and ancillary databases such as t-stat, etc.
We're in the process of redeploying some storage resources and have an opportunity to do it right.
If someone can point me in the right direction I'd greatly appreciate it.
Thanks!
Dan
----------------------------------------------------------
Daniel L Spees
Director, Information Services
Chicago Symphony Orchestra
312-294-3320
speesd@cso.org
Hi Dan,
I missed the TLCC session where flash storage came up, but we're using it to good effect.
We recently implemented a hybrid flash SAN in our on-site data centre. The most noticeable improvement was in read and write latency rather than IOPS. Our production Tessitura database spikes to around 300 IOPS. Even before implementing flash, we had that covered (though we've now got over 90k IOPS available across all workloads, where before we had 6k). On spinning disk we had latency of around 15ms. On flash, latency is under 1ms.
And while it's a hybrid SAN that still has spinning disk, we've pinned the database into flash. It never hits spinning disk.
Best regards,
Nic