OCZ fastens accelerator to Microsoft SQL Server 2014
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.
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.
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.