Architecting for Performance: Storage - Virtualizing SQL Server with VMware - page 197

Figure 6.42 ioTurbine dynamic and automatic allocation of flash cache.
Tip
Fusion-io has a tool called the ioTurbine Profiler that allows you to observe the
effects of caching on production or staged systems prior to investing in the
ioTurbine software and necessary hardware. The ioTurbine Profiler simulates the
effects of storage acceleration on a Linux or Windows system. For more
information, see http://www.fusionio.com/products/ioturbine-virtual/ .
Table 6.19 was obtained from Fusion-io performance test results published at
http://www.fusionio.com/blog/performance-of-a-virtualized-ms-sql-server-poor-
ioturbine-to-the-rescue . The results demonstrated that by offloading reads to the
ioTurbine flash cache, write performance also increased by just over 20%. This test
was based on TPC-E workload. This demonstrates that read caching can also improve
write performance to a certain extent.
Table 6.19 ioTurbine SQL Server Performance Example (TPC-E)
PernixData FVP
PernixData FVP is different from the other two solutions already discussed in that it