Violin array comes with new SQL sauce

Windows Flash Array

Beginner's guide to SSL certificates

Violin Memory's Steve Willson gave part of the game away on March 24, with a TechNet UK blog post: Violin's new array runs SQL 2014 in memory.

Willson wrote:

SQL 2014's new in-memory computing takes several leaps forward in performance and control. Application designers can now control what data is permanently staged in memory (thus reducing IO waits) and how machines compile the SQL code (for amazingly faster execution).

Willson pointed out: "If we could hold all SQL Server data in-memory using server DRAM, performance would be amazing, servers would be well utilised, applications would fly.” HE mentiuons severalo requirements beyond performance such as:

  • Business data needs to be stored safely on a mature persistent media
  • Business data needs to be accessed via multiple servers for high availability
  • Systems need to scale over time

He then writes: "These types of challenges demand a persistent storage solution that compliments the high performance of in-memory computing. In-memory database processing is enabled when the data can get into the system, be changed by the system and remain intact between events."

Persistent storage, hey? With multiple servers accessing it. We're thinking a Violin array fits the bill here.

SQL 2014 has a new, high-powered performance engine. It needs hardware, and Willson says Violin has it:

For branch office kits, archive targets or moderate workloads there is the Cluster In a Box class of products and for high end performance systems (SQL, SharePoint, Hyper-V farms, custom applications, etc) there is all-flash arrays like the new Violin Memory Windows Flash Array (WFA).

Our nose started twitching; a Violin WFA, as in not a VMware Flash Array or a KVM flash array or a Linux Flash Array. Sounds like Violin is not introducing a generic flash array but a Windows one, one to run SQL 2014. In fact, it might even be an existing Violin 6000 array with SQL 2014 software running in it.

Willson gives us more intel:

These all work off the same principle of Microsoft service to storage, operated by Windows Failover Clusters embedded inside of storage appliances. In the case of the WFA, Microsoft spent over a year tuning the kernel and I/O stack optimising for the world's fastest storage experience.

That year of tuning suggests existing array hardware will be used, or supported.

He closes off his blog by writing: "In-memory processing can now be enabled by a natively Windows-embedded storage appliance that allows for extreme write loads, high availability, scalability, reduced administration time and delivers the high speed data access to large reporting systems sitting next to the high end transactional systems. Storage is no longer the bottleneck keeping applications back and instead will empower the speeds of the new high performance engines like in SQL 2014."

A Google search revealed that SQLSaturday and its mass of unformatted text in the cached data was a little gold mine. Here are a few extracts:

  • SQLSaturday #275 – Copenhagen 2014 3/29/2014 ... SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server
  • Fusion-IO Platinum Sponsor
  • Violin Memory EMEA Limited Platinum Sponsor

Of course! It's not just Violin getting favoured by Microsoft with SQL 2014, Fusion-io is in there too.

Here's a session description:

Meet the Windows Flash Array (WFA) – Windows 2012 R2 + Violin Memory Array in one product, delivering huge performance for SQL Server and HyperV – Simplified with SMB3/SMB Direct! Finally a storage solution without compromises, but still very easy to use. Full IO performance with unique Violin Memory technology delivering equal fast performance for Reads and Writes. No complicated storage configuration and tuning – equally fast with sequential and random loads. Effective and simple use of SMB Direct on either 10G Ethernet or 56G Infiniband networks. Up to 40TiB usable capacity within 3U or utilize Win2k12R2 ScaleOutFileSystem (SOFS) to create a pool with 160TiB. Management and monitoring directly from Microsoft System Center.

And here is a Fusion-io session description:

Leveraging Buffer Pool Extension and In-Memory OLTP in SQL Server 2014 with Fusion's ioDrive2 product line increases database performance by allowing solid state storage to exist alongside DRAM. Fusion’s memory-like performance helps reduce costs by enabling organisations to scale with NAND flash versus DRAM.

So we think SQL Server 2014 comes with in-memory OLTP built-in, and maybe Violin's 6000 arrays can take advantage of it to speed SQL processing by having Windows Server 2012 R2 booted on its internal server nodes, and they then run SQL Server 2014. Or there is new hardware and/or array OS software as well?

So too will Fusion-io's PCIe flash ioMemory technology with Windows Server and SQL 20-14 running on the host server.

What we haven't accounted for is Violin's assertion that the coming arrays will have deduplication, replication, and snaps. New Violin software maybe? Or is Violin referring to a deduplication feature in Windows Server 2012 R2? Darn it; we need to do more work. ®

Beginner's guide to SSL certificates

More from The Register

next story
The cloud that goes puff: Seagate Central home NAS woes
4TB of home storage is great, until you wake up to a dead device
Fat fingered geo-block kept Aussies in the dark
You think the CLOUD's insecure? It's BETTER than UK.GOV's DATA CENTRES
We don't even know where some of them ARE – Maude
Intel offers ingenious piece of 10TB 3D NAND chippery
The race for next generation flash capacity now on
Want to STUFF Facebook with blatant ADVERTISING? Fine! But you must PAY
Pony up or push off, Zuck tells social marketeers
Oi, Europe! Tell US feds to GTFO of our servers, say Microsoft and pals
By writing a really angry letter about how it's harming our cloud business, ta
Astro-boffins start opening universe simulation data
Got a supercomputer? Want to simulate a universe? Here you go
prev story


Why cloud backup?
Combining the latest advancements in disk-based backup with secure, integrated, cloud technologies offer organizations fast and assured recovery of their critical enterprise data.
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.
Getting ahead of the compliance curve
Learn about new services that make it easy to discover and manage certificates across the enterprise and how to get ahead of the compliance curve.
Storage capacity and performance optimization at Mizuno USA
Mizuno USA turn to Tegile storage technology to solve both their SAN and backup issues.