Sign in to follow this  
Followers 0
Brian

SQL
OCZ ZD-XL SQL Accelerator Review Status

7 posts in this topic

We've started testing the OCZ ZD-XL SQL accelerator solution. We're using 16x900GB WD Xe HDDs in an iXSystems JBOD as a baseline and comparing those results against the 1.6 TB ZD-XL (Z-Drive R4 tuned for SQL caching). SQL testing is being driven by up to 20,000 virtual users in Benchmark Factory's TPC-C workload.

We'll update this thread as we progress and are open to fielding questions or comments on the solution at large. More background information is available here -

http://www.storagereview.com/ocz_zdxl_sql_accelerator_released_integrated_flash_hardware_and_software_solution

Share this post


Link to post
Share on other sites

Seeing some good latency improvements in our HDD vs HDD+ZD-XL configuration in our new SQL Server benchmark. Latency dropping 2x at the higher levels.

post-47697-0-06811600-1383687998_thumb.p

1 person likes this

Share this post


Link to post
Share on other sites

Had a data review call with OCZ today on this review, all is looking good for the TPC-C results. Next we will be moving on to database performance when pinned entirely on the ZD-XL card. Interestingly the ZD-XL solution can do both things, accelerate a HDD volume as well as put the entire SQL database in flash if the user chooses.

Share this post


Link to post
Share on other sites

Configured the ZD-XL for a split cache/flash volume using 1.2TB for a SQL Server database and about 300GB leftover for caching.

post-47697-0-08743900-1383772147_thumb.p

Share this post


Link to post
Share on other sites

Wrapped up our 1.1TB TPC-C database test on the ZD-XL (fitting all inside the flash volume), which ended up boasting the lowest latency scores we've measured to date from a PCIe SSD.

post-47697-0-54164100-1383837935_thumb.p

Share this post


Link to post
Share on other sites

Working through continued testing, still very impressed by the raw bandwidth from the ZD-XL. 2.7GB/s during a DB check going into a benchmark run.

post-47697-0-05698400-1384538899_thumb.p

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0