Brian 154 Report post Posted November 5, 2013 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
Kevin OBrien 57 Report post Posted November 5, 2013 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. 1 Share this post Link to post Share on other sites
Brian 154 Report post Posted November 6, 2013 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
Kevin OBrien 57 Report post Posted November 6, 2013 Configured the ZD-XL for a split cache/flash volume using 1.2TB for a SQL Server database and about 300GB leftover for caching. Share this post Link to post Share on other sites
Kevin OBrien 57 Report post Posted November 7, 2013 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. Share this post Link to post Share on other sites
Kevin OBrien 57 Report post Posted November 15, 2013 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. Share this post Link to post Share on other sites
Brian 154 Report post Posted January 13, 2014 The review is complete and live here - http://www.storagereview.com/ocz_zdxl_sql_accelerator_review Share this post Link to post Share on other sites
