Fusion-io ioMemory Unlocks Performance for SQL Server 2014

Fusion-io, Inc. announced its ioMemory platform has been optimized for performance with SQL Server 2014.

The platform builds upon the in-memory innovation in SQL Server 2014, delivering up to 4x improvements in transactions per second and a reduction in data latencies in the company’s testing. The transactional performance from Fusion-io flash memory products drives real-time insights for faster business decisions.

The platform and software defined storage solutions accelerate virtualization, databases, cloud computing, big data and performance applications. From e-commerce retailers to the world’s social media leaders and Fortune Global 500 companies, customers are improving the performance and efficiency of their data centers with Fusion-io technology to accelerate the critical applications of the information economy.

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 OLTP that speeds the process to analyze 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 a 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, GM, SQL Server product marketing, Microsoft Corp. “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 TCO.”

“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 COO. “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 TCO.”

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 changing market conditions. ioMemory offers tens of terabytes of performance flash per server to deliver real-time business insights at a fraction of the cost of scaling out disks for performance. Persistent, high capacity ioMemory platform gives servers native access to flash memory to increase datacenter efficiency, with enterprise grade performance, reliability, availability, and manageability.

The 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 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 reduce the amount of user wait time throughout their database environment. ioMemory integrates into the SQL Server 2014 Database Engine buffer pool to 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 ioMemory platform increases database performance by allowing solid-state storage to exist alongside DRAM. Fusion memory-like performance helps reduce costs by enabling organizations 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.

Fusion-io will embark on a 35-city tour appearing at Microsoft Technology Centers (MTCs) worldwide to showcase how ioMemory products maximize SQL Server 2014.