OCZ Technology Delivers the Plug-and-Play SQL Server Optimized ZD-XL SQL Accelerator
Tightly Integrated PCIe Solid-State Drive Hardware and Enterprise Software Storage Solution Accelerates and Optimizes Microsoft SQL Server Applications
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 user-friendly advanced 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,” said Ralph Schmitt, CEO for OCZ Technology. “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.”
“By deploying ZD-XL SQL Accelerator in our database servers, we reduced the run time of key SQL Server jobs from 2.5 hours to 45 minutes, without replacing our SAN,” said Lars Ketting, ICT, Cartal Rijsbergen Automotive. “Along with these performance benefits, the simple implementation wizards allowed us to easily migrate from our test environment to deployment in our production systems.”
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.
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. For more information, go to www.ocz.com/enterprise