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

Internet Security Threat Report 2014

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. ®

Intelligent flash storage arrays

More from The Register

next story
Just don't blame Bono! Apple iTunes music sales PLUMMET
Cupertino revenue hit by cheapo downloads, says report
The DRUGSTORES DON'T WORK, CVS makes IT WORSE ... for Apple Pay
Goog Wallet apparently also spurned in NFC lockdown
IBM, backing away from hardware? NEVER!
Don't be so sure, so-surers
Hey - who wants 4.8 TERABYTES almost AS FAST AS MEMORY?
China's Memblaze says they've got it in PCIe. Yow
Microsoft brings the CLOUD that GOES ON FOREVER
Sky's the limit with unrestricted space in the cloud
This time it's SO REAL: Overcoming the open-source orgasm myth with TODO
If the web giants need it to work, hey, maybe it'll work
'ANYTHING BUT STABLE' Netflix suffers BIG Europe-wide outage
Friday night LIVE? Nope. The only thing streaming are tears down my face
Google roolz! Nest buys Revolv, KILLS new sales of home hub
Take my temperature, I'm feeling a little bit dizzy
Storage array giants can use Azure to evacuate their back ends
Site Recovery can help to move snapshots around
prev story

Whitepapers

Why and how to choose the right cloud vendor
The benefits of cloud-based storage in your processes. Eliminate onsite, disk-based backup and archiving in favor of cloud-based data protection.
Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
Protecting users from Firesheep and other Sidejacking attacks with SSL
Discussing the vulnerabilities inherent in Wi-Fi networks, and how using TLS/SSL for your entire site will assure security.