I have one VCenter instance and 3 ESXi hosts - 1 running 5.5 and 2 running 5.1U1. I was going to upgrade the two that are behind pretty soon. But, while doing some work in VCenter yesterday the virtual flash cache options caught my eye.
One of the hosts I have runs a SQL 2008 box which serves as the back end database for our Epicor ERP system. There's also a server on that same host that acts as an Epicor application server. The server is a Cisco UCSC-C240-M3S with a couple of Xeon E5-2665 processors, 128 GB RAM, and 16 300 GB 10K SAS drives in OBR 10. Epicor speed is still better than it was before we went virtual (take that, Epicor), but people always want faster. If I could throw a couple of SSDs in some of the 8 extra drive bays we have, it would really give us a boost.
For those that have used SSDs as a cache device with VSphere 5.5, how much improvement have you seen for database servers? We are about 85/15 read/write but getting closer to 80/20.
And moreover, how many SSDs should I use for flash in this host if I were to do it?