Fusion-io unlocks performance for SQL Server 2014

Fusion-io has announced that the Fusion ioMemory platform has been optimised for performance with SQL Server 2014. The Fusion ioMemory platform builds upon the in-memory innovation in SQL Server 2014, delivering up to 4x improvements in transactions per second and a significant reduction in data latencies in our testing. The transactional performance from Fusion-io flash memory products drives real-time insights for faster business decisions.

To remain competitive, enterprises must quickly gather real-time intelligence to make informed business decisions. SQL Server 2014 delivers new in-memory capabilities built into the core database for online transaction processing (OLTP) that massively speeds the process to analyse real-time transaction data. SQL Server 2014 In-Memory OLTP combined with the Fusion-io cut through architecture drives the highest performance level of transactions with the simplest, most cost-effective approach compared to legacy architectures.

“We have seen in-Memory OLTP capabilities in SQL Server 2014 provide tremendous performance improvements to business applications,” said Eron Kelly, general manager, SQL Server product marketing, Microsoft. “Adding the Fusion ioMemory platform to an existing SQL Server 2014 in-memory OLTP configuration can deliver up to 4x additional performance gains, building on our in-memory innovation to provide even greater performance benefits so customers can quickly uncover valuable business insights from their data and transform their business with greater scale at a low total cost of ownership.”

“We are entering the age of in-memory databases and Microsoft’s adoption of in-memory OLTP is a critical step in that direction,” said Lance Smith, Fusion-io President and Chief Operating Officer. “SQL Server 2014 with Fusion ioMemory provides a competitive advantage by allowing real-time access to information, unparalleled performance gains on tasks and a lower total cost of ownership.”

Fusion-io flash memory products answer the expectation of immediacy. A Fusion powered SQL Server 2014 In-Memory OLTP database drives business impact by helping customers adapt more quickly to ever-changing market conditions. Fusion ioMemory offers tens of terabytes of high-performance flash per server to deliver real-time business insights at a fraction of the cost of scaling out disks for performance. Fusion-io’s persistent, high capacity ioMemory platform gives servers native access to flash memory to significantly increase datacentre efficiency, with enterprise grade performance, reliability, availability, and manageability.

The Fusion ioMemory platform is trusted by thousands of customers around the world to accelerate mission critical applications that power their businesses. SQL Server 2014 customers that deploy Fusion ioMemory discover direct bottom-line impact on their business by leveraging existing hardware investments without sacrificing performance. Fusion-io also improves productivity and enhances the overall user experience for enterprises by accelerating SQL Server 2014 response times.

Fusion-io also supports Buffer Pool Extension, a new feature in SQL Server 2014. With Buffer Pool Extension and low latency Fusion-io flash memory, customers now have the ability to drastically reduce the amount of user wait time throughout their database environment. Fusion ioMemory seamlessly integrates into the SQL Server 2014 Database Engine buffer pool to significantly improve I/O throughput and reduce disk latency by offloading clean data pages from traditional storage to flash.
Integration between Buffer Pool Extension in SQL Server 2014 and the Fusion ioMemory platform increases database performance by allowing solid-state storage to exist alongside dynamic random-access memory (DRAM). Fusion memory-like performance helps reduce costs by enabling organisations to scale with NAND flash versus DRAM. The simplicity of Buffer Pool Extension and performance of Fusion’s flash technology not only makes Buffer Pool Extension easy to implement, it also allows other applications to reside on Fusion’s ioMemory products which demand greater I/O.