Fusion's ioMemory platform transforms flash into an optimal media for Microsoft SQL Server databases, eliminating the primary performance and scalability constraints of I/O bottlenecks and long latencies.
ioMemory offers Microsoft SQL Server Databases the following:
New features in SQL Server 2012 give enterprises the means to easily implement scalable, high-performing, and highly available server-centric architectures. These architectures allow organizations to meet growing performance needs cost-effectively, and without sacrificing the availability that mission-critical applications require.
ioMemory accelerates AlwaysOn:
ioMemory accelerates readable mirrors for the following benefits:
On top of it all, ioMemory speeds migration, making upgrading from 2008 or 2005 easier than it has ever been before.
This configuration achieves High Availability and disaster recovery via a single Availability Group for databases at different geographic locations.A Primary and a Secondary database are synchronously mirrored at one site, while a disaster recovery databases is mirrored asynchronously at a second site (the DR server could also have a failover).
In addition to greatly improving database query performance, ioMemory also speeds replication and failover times to enhance the high availability profile.
This configuration optimizes hardware efficiency. The secondary server is a readable mirror and failover. The readable mirror offloads tasks like reporting and backups to improve both the performance of live database queries and the secondary tasks.
ioMemory dramatically improves both query performance and reporting/maintenance tasks to extend this performance and efficiency to much larger data sets.
Microsoft has formally adopted storing tempDB on local storage for best practices. Organizations can greatly accelerate the performance of databases with active tempDB files by storing tempDB on ioMemory instead of hard disks.