Violin array comes with new SQL sauce

Windows Flash Array

Internet Security Threat Report 2014

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

Choosing a cloud hosting partner with confidence

More from The Register

next story
NSA SOURCE CODE LEAK: Information slurp tools to appear online
Now you can run your own intelligence agency
Fat fingered geo-block kept Aussies in the dark
Yahoo! blames! MONSTER! email! OUTAGE! on! CUT! CABLE! bungle!
Weekend woe for BT as telco struggles to restore service
Cloud unicorns are extinct so DiData cloud mess was YOUR fault
Applications need to be built to handle TITSUP incidents
Stop the IoT revolution! We need to figure out packet sizes first
Researchers test 802.15.4 and find we know nuh-think! about large scale sensor network ops
Turnbull should spare us all airline-magazine-grade cloud hype
Box-hugger is not a dirty word, Minister. Box-huggers make the cloud WORK
SanDisk vows: We'll have a 16TB SSD WHOPPER by 2016
Flash WORM has a serious use for archived photos and videos
Astro-boffins start opening universe simulation data
Got a supercomputer? Want to simulate a universe? Here you go
Do you spend ages wasting time because of a bulging rack?
No more cloud-latency tea breaks for you, users! Get a load of THIS
prev story


Free virtual appliance for wire data analytics
The ExtraHop Discovery Edition is a free virtual appliance will help you to discover the performance of your applications across the network, web, VDI, database, and storage tiers.
Getting started with customer-focused identity management
Learn why identity is a fundamental requirement to digital growth, and how without it there is no way to identify and engage customers in a meaningful way.
The total economic impact of Druva inSync
Examining the ROI enterprises may realize by implementing inSync, as they look to improve backup and recovery of endpoint data in a cost-effective manner.
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?
Website security in corporate America
Find out how you rank among other IT managers testing your website's vulnerabilities.