Monday, July 14th 2014

OCZ Storage Solutions Launches Next Generation ZD-XL SQL Accelerator

OCZ Storage Solutions - a Toshiba Group Company and leading provider of high-performance solid-state drives (SSDs) for computing devices and systems, today announced the introduction and availability of its next generation SQL Server acceleration solution. The new ZD-XL SQL Accelerator 1.5 supports Microsoft SQL Server 2014, 2012 and 2008 R2 versions expanding on the key flash-based storage features that improve I/O access performance. OCZ presents the new SQL accelerator today through July 17th at the Microsoft Worldwide Partner Conference (WPC) 2014, Booth #2506A, Walter E. Washington Convention Center, Washington, DC.

ZD-XL SQL Accelerator 1.5 provides optimized and efficient flash acceleration for SQL Server through unique integration with the application and has been enriched over the previous ZD-XL 1.0 version to enable database administrators (DBAs) to unleash the full power of SQL Server 2014 features, such as flash Buffer Pool Extension (BPE) support, so that database pages can be accessed faster by loading them directly from flash.
New ZD-XL SQL Accelerator 1.5 features in support of SQL Server 2014 include:
  • Tight integration with SQL Server management enabling acceleration at a per database level versus having to accelerate all of the databases files on disk. This provides fine granularity for selecting only those database files that need to be accelerated.
  • Support for running SQL in a virtualized environment via VMware ESXi and Microsoft Hyper-V enabling the flash resources to support multiple virtual machines (VMs) running SQL Server workloads concurrently. High Availability (HA) through the Microsoft AlwaysOn Availability Group is supported as well.
  • Remote flash services enabling SQL Server to run on blade servers so they can benefit from the high-performance and high density of PCIe flash storage. This unique feature enables a remote connection over the network between SQL Server and the PCIe flash resource to deliver remote flash caching via OCZ's proprietary Direct Pass Caching Technology.
"Our next generation SQL accelerator extends the SQL Server 2014 flash storage feature-set and uniquely exposes our PCIe-based on-host flash resources as local flash volumes, a flash cache for HDD volumes, or any combination of both, efficiently distributing random workloads in parallel between all of its available flash," said Daryl Lang, SVP of Product Management for OCZ Storage Solutions. "This unrivalled flash partitioning enables transient files (such as tempDB) to benefit from fast flash performance while hot data is cached to flash for immediate availability by SQL Server."

The performance increases delivered by ZD-XL SQL Accelerator 1.5 are beneficial to small and medium-sized businesses (SMBs) as well as larger enterprises/data centers and based on database transactions per minute (TPM). Internal testing performed by OCZ delivered over one million TPMs for a sample of 50 virtual users when ZD-XL SQL Accelerator 1.5 was located in the same server as the SQL application. This represented a TPM increase ranging from 18x to 22x for a local HDD-based configuration so the additional performance increases not only reduce an SMB's need to invest in costly SAN and HDD storage, but protects their storage investment when they migrate to SQL Server 2014.

For larger enterprises/data centers that use ZD-XL SQL Accelerator 1.5 in a traditional SAN storage environment, the embedded software can cache large database files from the SAN onto server-side flash either locally or remotely. As a result, ZD-XL SQL Accelerator 1.5 achieved accelerated TPM performance up to 5x dependent on the performance of the SAN and the number of virtual users supported. Though performance gains may not be as high as an SMB using a local HDD configuration, performance is improved over a SAN while keeping the data highly available.

Payment processing is a SQL Server application dependent on the low-latency processing of multiple concurrent I/O commands. The processing of these commands must be as fast as possible as a large amount of small transactions are time-sensitive. In payment processing applications, storage is often the bottleneck. So as part of the development process, OCZ delivered a beta version of ZD-XL SQL Accelerator 1.5 to selective payment processing companies for their evaluation:
"With our business expanding and workloads increasing, we need the fastest and safest solutions to keep our transaction processing times to a minimum without sacrificing peace of mind, and the ZD-XL 1.5 solution is by far the fastest solution we have found to date," said Prevan Pillay, DBA for Tutuka Software, the largest prepaid card processing company in South Africa. "The caching system was innovative, so regardless of how many read or write operations performed, ZD-XL 1.5 maintained superlative and consistent speed that helped us lower processing times on SQL databases."

The new ZD-XL SQL Accelerator 1.5 is available in three Multi-Level Cell (MLC) configurations supporting 800 GB, 1.6 TB and 3.2 TB storage capacities in a Full-Height/Half-Length form factor. Service and support options are available for each configuration. More information is available at
Add your own comment

6 Comments on OCZ Storage Solutions Launches Next Generation ZD-XL SQL Accelerator

Only the Enterprise series got such a good support and there will have to OCZ Thoshiba come down to all the products if they wish to maintain market since Samsung with its wizard offered good support at any level of the product and preformence technology and price offers much more. I prefer buy 4x1Tb x 300 € Samsung EVO and connect them in RAID than to pays twice more for name. Not to mention the 850PRO and rapid ....
OCZ he thinks it is best not to invest in the normal consumers.Those days are long gone. Regular customers are the biggest buyer !
Posted on Reply
There is plenty of room for expansion in the Enterprise market. I don't think wise Enterprise customers are going to be ditching enterprise products for the Samsung Evo hooked to Magician Nvelo-made caching any time soon so that is not really a valid comparison. Samsung might have a wizard in support but Enterprise customers aren't going to sell that to any CEO/CFO - even if that wizard is Gandalf himself.
Posted on Reply
This is something totally different than Samsung Evo and their Magician.
We use them in our VMware farm to cache/accelerate our SQL databases.

OCZ/Toshiba has Enterprise software and support that far surpasses Samsungs.

I would say the Samsung EVO, which I use myself, as a home user, is good for home users and heavy workstations - but not for enterprise use.....
Posted on Reply
the idea and usage sounds great. the brand however..
I wouldnt put my data on OCZ storage, even if my job depended on it.. oh wait, it does, hence why I wouldnt trust this as far as i could throw it.
Posted on Reply
qwerty_lesh said:
the idea and usage sounds great. the brand however..
I wouldnt put my data on OCZ storage, even if my job depended on it.. oh wait, it does, hence why I wouldnt trust this as far as i could throw it.
What a dumb comment - based on what ????
Posted on Reply
based on my grounded bias from processing their abnormally high warranty rates (for years - as in upto hundreds of ocz consumer grade ssd RMAs per quarter..) prior to them going bust.

I dont care who purchased them, the brands tainted.
Posted on Reply