Global Sources
EE Times-Asia
Stay in touch with EE Times Asia
 
EE Times-Asia > Memory/Storage
 
 
Memory/Storage  

OCZ fastens accelerator to Microsoft SQL Server 2014

Posted: 21 Jul 2014  Print Version  Bookmark and Share

Keywords:Microsoft SQL Server  accelerator  OCZ 

In only a few months since its acquisition at the beginning of the year, OCZ Storage Solutions has stepped forward as a Toshiba-owned company with an update to its ZD-XL SQL Accelerator featuring support for the latest version of Microsoft SQL Server.

Michael Yam, OCZ's director of business development, told EE Times that the ZD-XL SQL Accelerator 1.5 builds on the features of its predecessor, which was launched a year ago. The new version supports a full range of SQL Server 2014 features, said including flash Buffer Pool Extension support, so that database pages can be accessed faster by loading them directly from flash.

image name

The update to version 1.5 features several optimisations for Microsoft SQL Server applications. Source: OCZ

A unique feature of the ZD-XL SQL Accelerator 1.5 is the ability to partition flash as a cache or a volume as required based on workloads, Yam said. The ZD-XL SQL Accelerator architecture allows for low-latency flash to be deployed as local flash volumes, a flash cache for HDD volumes, or a combination of both. Partitioning flash resources between local volumes and cache enables tempDB files to take advantage of the media's flash performance while "hot" data can be cached from larger databases for immediate SQL server availability.

OCZ has focused on making its ZD-XL SQL Accelerator easy for database administrators (DBAs) to configure without requiring any storage expertise by deeply integrating it with SQL Server, enabling them to manage the system using wizards, he said. This integration also supports acceleration at a per-database level, rather than having to accelerate all the database files on disc. DBAs can select only those files that need to be accelerated.

image name

Direct Pass Caching Technology efficiently selects what data to place in flash cache so that the right data is selected for the specific workload. Source: OCZ

Other features added to the ZD-XL SQL Accelerator 1.5 include support for running SQL in a virtualised environment through VMware ESXi and Microsoft Hyper-V, so flash resources can support multiple virtual machines running SQL Server workloads concurrently. The update also adds remote flash services to allow SQL Server to run on blade servers, so they can benefit from the high performance and density of PCIe flash storage. In addition, a connection can be set up over the network between SQL Server and the PCIe flash resource to deliver remote flash caching.


1 • 2 Next Page Last Page



Article Comments - OCZ fastens accelerator to Microsoft...
Comments:  
*  You can enter [0] more charecters.
*Verify code:
 
 
 
Webinars

Seminars

Visit Asia Webinars to learn about the latest in technology and get practical design tips.

 
 
Back to Top