Feeds

Fusion-io: Ah, Microsoft. I see there's in-memory in SQL Server 2014... **GERONIMO!**

Server flasher leaps in to fulfil need for SQL speed

Top 5 reasons to deploy VMware with Tegile

Microsoft has given SQL Server2014 an in-memory operation ability and server flasher Fusion-io has quickly jumped in to take advantage.

Its ioMemory product can run the in-memory flavour of SQL Server and deliver, Fusion claims, ”up to 4x improvements in transactions per second and a significant reduction in data latencies in our testing.”

Eron Kelly, Microsoft’s general manager for SQL Server product marketing (jeez, nice title) said: “We have seen in-Memory OLTP capabilities in SQL Server 2014 provide tremendous performance improvements to business applications.

"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.”

Nice.

So Fusion-io can do in the commodity server what Violin Memory can do in the server inside its networked array. Wonder which is faster, has a better price, is easier to manage, etc?

Fusion ioMemory also "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". The Fusion NAND co-exists with the host server’s DRAM and offers what is called storage-class memory, slower than DRAM, less expensive than DRAM and much faster than disk in latency terms.

Other database and OLTP application suppliers will probably have to offer in-memory options if they haven't already done so. Likewise we'd expect WD's (HGST's actually) Virident to play nice with SQL Server 2014 too.

Our understanding is that unlike Fusion-io and Violin Memory, ordinary PCIe flash with caching software is not compatible with SQL Server 2014 – giving these two firms, and HGST's Virident if it goes the same way, an advantage over the general run of PCIe flash card vendors. ®

Beginner's guide to SSL certificates

More from The Register

next story
It's Big, it's Blue... it's simply FABLESS! IBM's chip-free future
Or why the reversal of globalisation ain't gonna 'appen
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
Microsoft and Dell’s cloud in a box: Instant Azure for the data centre
A less painful way to run Microsoft’s private cloud
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
CAGE MATCH: Microsoft, Dell open co-located bit barns in Oz
Whole new species of XaaS spawning in the antipodes
AWS pulls desktop-as-a-service from the PC
Support for PCoIP protocol means zero clients can run cloudy desktops
prev story

Whitepapers

Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.