Jump to content


Photo

OCZ ZD-XL SQL Accelerator Review Status

SQL OCZ PCIe

  • You cannot start a new topic
  • Please log in to reply
6 replies to this topic

#1 Brian

Brian

    SR Admin

  • Admin
  • 5,298 posts

Posted 05 November 2013 - 04:41 PM

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.storagere...ftware_solution


Brian

Publisher- StorageReview.com
Twitter - @StorageReview

 

#2 Kevin OBrien

Kevin OBrien

    StorageReview Editor

  • Admin
  • 1,441 posts

Posted 05 November 2013 - 04:46 PM

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.

 

 

Attached Thumbnails

  • ZD-XL.png

#3 Brian

Brian

    SR Admin

  • Admin
  • 5,298 posts

Posted 06 November 2013 - 02:42 PM

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. 


Brian

Publisher- StorageReview.com
Twitter - @StorageReview

 

#4 Kevin OBrien

Kevin OBrien

    StorageReview Editor

  • Admin
  • 1,441 posts

Posted 06 November 2013 - 04:09 PM

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

 

ZDXL.png


#5 Kevin OBrien

Kevin OBrien

    StorageReview Editor

  • Admin
  • 1,441 posts

Posted 07 November 2013 - 10:25 AM

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.

Attached Thumbnails

  • ZD-XL-flash.png

#6 Kevin OBrien

Kevin OBrien

    StorageReview Editor

  • Admin
  • 1,441 posts

Posted 15 November 2013 - 01:08 PM

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.

 

ZDXL-read.png


#7 Brian

Brian

    SR Admin

  • Admin
  • 5,298 posts

Posted 13 January 2014 - 03:22 PM

The review is complete and live here - 

 

http://www.storagere...elerator_review


Brian

Publisher- StorageReview.com
Twitter - @StorageReview

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users