OCZ has issued yet another whitepaper written by Allon Cohen PhD, Yaron Klein, Scott Harlin, Eli Ben Namer, David Dorham and Rodolfo Campos which focuses on performance test results for Analytical (OLAP) and Transactional (OLTP) SQL Server 2012 loads with OCZ's ZD-XL SQL accelerated SQL Server 2012.

The whitepaper addresses key elements required to efficiently accelerate SQL Server applications via flash volumes, flash caching, cache policy optimizations and cache pre-warning and how those elements are seamlessly designed into ZD-XL SQL Accelerator architecture. The new whitepaper focuses on application load testing results performance in both analytical and transactional environments.

The important aspects of the Microsoft SQL Sever 2012 enterprise database management system include data access latency and transactional input/output operations per second (IOPS) as well as access rates and database read latencies which allow optimal performance as well as shorten the time it takes to complete analytical queries in data environments. The OCZ ZD-XL SQL Accelerator is designed to provide optimized and efficient flash acceleration for SQL Server environments via tight integration of both hardware and software elements.

In order to simulate a typcial data warehouse application, the performance tests included a 1.7TB database to run data warehouse queries based on the TPC-H query set and include results from both MS SQL Server 2012 with and without the ZD-XL SQL Accelerator. The test results include a total of 22 benchmark analytical queries.

The test results show that OCZ's ZD-XL SQL Accelerator, which is tightly integrated hardware/software enterprise plug-and-play solution, can accelerate SQL Server OLTP And OLAP workloads, thanks to accelerated flash performance via caching policies, which results in high hit ratios for most relevant SQL data. The tight integration of flash hardware, acceleration software, firmware and driver delivers an immediate performance boost, reduced TCO and improved productivity whether the environment is SAN-based or SAN-less.








Source: OCZ.com.