News
 

Bookmark and Share

(0) 

OCZ Technology Group, a leading provider of high-performance solid-state drives (SSDs), has announced the general availability of its ZD-XL SQL Accelerator. This product is a tightly integrated hardware/software storage solution that accelerates and optimizes Microsoft SQL Server database applications in enterprise environments.

ZD-XL SQL Accelerator is available in three configurations supporting 600GB, 800GB and 1.6TB storage capacities with service and support options available for each. ZD-XL SQL Accelerator includes a high-performance flash-based PCIe solid-state drive working in combination with innovative acceleration and caching software to deliver the right and relevant SQL Server data when the application needs it. Through a graphical user interface, ZD-XL provides simple step-by-step implementation wizards that guide database administrators (DBAs) through best practice models of its flash-based resources to deliver easy and efficient deployment into SQL Server environments.

The unique ZD-XL SQL Accelerator architecture exposes its PCIe-based on-host flash as both local and cache volumes, and efficiently distributes random database workloads in parallel between all of its available flash to provide up to 25 times improved database performance depending on the application load. The ZD-XL SQL Accelerator's unrivaled ability to partition its flash between local volumes and cache enables data files, such as tempDB, to benefit from high flash performance while hot database data is cached to flash for immediate availability by SQL Server.

"Plugging seamlessly into existing or new SQL Server installations, our new ZD-XL SQL Accelerator leverages both our solid-state drive hardware and software IP to provide application-optimized flash caching load volumes that enable data to be accessed with the highest possible I/O performance. We believe that the industry is primed for this type of tightly integrated, plug-and-play use-case acceleration solution that uniquely combines software, driver, firmware and hardware into one robust and easy to deploy high-performance SQL Server solution," said Ralph Schmitt, chief executive officer of OCZ Technology.

Direct pass caching technology is a key component of ZD-XL SQL Accelerator as it intelligently selects what data to insert into flash cache. The technology utilizes a data path cache director, cache analysis engine, and advanced policy-based algorithms that enable DBAs to use pre-optimized SQL Server-specific caching policies. This one-of-a-kind decision-engine performs deep 'out-of-band' statistical analysis of both OLTP (transactional) and OLAP (analytical) loads, making knowledgeable selections that ensure high hit ratios of the most frequent and important hot data to cache within ZD-XL SQL Accelerator without having to perform cycle-consuming analysis in the data path itself.

Another key feature of ZD-XL SQL Accelerator is its business-rule pre-warming cache engine and cache warm-up analyzer that monitors SQL Server workloads and automatically pre-loads the cache in advance of critical, demanding or important SQL Server jobs. It achieves this by identifying repeated access patterns that enable DBAs to set periodic time schedules to pre-load the cache. This unparalleled feature assures that this critical data resides on the ZD-XL SQL Accelerator's cache at the exact time SQL Server needs it.

To round out its capabilities, ZD-XL SQL Accelerator is designed to enable complete high availability (HA) through Microsoft SQL Server AlwaysOn technology, so not only can SQL Server environments function at the speed of flash, but in the event of planned or unplanned downtime, can continue operations from the stopping point, retaining all of its data as if no downtime had occurred.

Tags: OCZ, SSD, ZD-XL, Microsoft, SQL, NAND, Flash

Discussion

Comments currently: 0

Add your Comment




Related news

Latest News

Sunday, August 24, 2014

6:12 pm | Former X-Bit Labs Editor Aims to Wed Tabletop Games with Mobile Platforms. Game Master Wants to Become a New World of Warcraft

Thursday, August 21, 2014

10:59 pm | Khronos Group to Follow DirectX 12 with Cross-Platform Low-Level API. Khronos Unveils Next-Generation OpenGL Initiative

10:33 pm | Avexir Readies 3.40GHz DDR4 Memory Modules. DDR4 Could Hit 3.40GHz This Year

12:10 pm | AMD to Lower Prices of A-Series APUs for Back-to-School Season. New Prices of AMD A-Series APUs Revealed

Wednesday, August 20, 2014

10:53 am | AMD to Cut Prices on FX-9000, Other FX Processors: New Prices Revealed. AMD to Make FX Chips More Affordable, Discontinue Low-End Models

10:32 am | LG to Introduce World’s First Curved 21:9 Ultra-Wide Display. LG Brings Curved Displays to Gamers, Professionals

9:59 am | AMD Readies FX-8370, FX-8370E Microprocessors. AMD Preps Two New “Mainstream” FX Chips