Fusion-io's SQL Server-snuggle

Second only to the programming spin that focuses on DevOps is the emergence of what we might call the rise of the true ‘data developer’.

The data (or database) developer is focused on tools that can reduce transaction latencies inside modern data warehouse environments, very often now employing in-memory computing speed where possible.

This is the target zone that Fusion-io is looking to with its news this week that the Fusion ioMemory platform has been optimised for performance with Microsoft SQL Server 2014.

First the Earth cooled

So first the Earth cooled, then the dinosaurs came… and then Microsoft adorned SQL Server 2014 with in-memory capabilities with perhaps half an eye on what SAP has done with its HANA IMDB flagship loveliness.

The Fusion ioMemory platform is said to be capable of running the in-memory SQL Server 2014 proposition at a 4x improvement in transactions per second with lower data latencies.

So just to restate the facts… SQL Server 2014 delivers new in-memory capabilities built into the core database for online transaction processing (OLTP) to speed real-time transaction data.

Cut-through architecture

Fusion-io now claims that 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.

“The move by Microsoft to adopt in-memory on-line transaction processing (OLTP) for SQL Server 2014 is a huge step forwards towards the needs businesses around the world have for in-memory databases. In-memory provides businesses with a competitive advantage by allowing real-time access to information, by adding flash memory technology to this it removes additional data bottlenecks to provide faster transactions, faster queries and faster insights at lower costs for businesses,” said Fusion-io President and COO Lance Smith.

Fusion ioMemory offers tens of terabytes of high-performance flash per server at “a fraction of the cost” (it says here) of scaling out disks for performance.

Fusion-io’s persistent, high capacity ioMemory platform gives servers native access to flash memory with the intention of increasing datacentre efficiency.

Fusion-io also supports Buffer Pool Extension, a new feature in SQL Server 2014.


Image 1: Fusion-io’s understated modest low-key home page imagery, do you think they’re trying to tell us something?