Data Center Tech Blog

Developed jointly with HPE, Grant Jacobson shares more on the testing results of a new SQL Server database cache acceleration solution using FlashSoft® caching software, SanDisk-based HPE flash and HPE NVDIMMs, as previewed at Discover 2016

In my recent post about our presence this week in Las Vegas at the HP Enterprise Discover 2016 event, I shared that we will be showcasing several new solutions. With the unveiling at the event, I want to share with you the new SQL Server Database Cache Acceleration Solution that we are previewing in our booth. This was developed jointly with HPE and uses FlashSoft® caching software from SanDisk® to accelerate a tier of SanDisk-based HPE flash and HPE NVDIMMs.

High Performance, Cost-Effective Acceleration

Latency is a critical factor for database acceleration and performance, and this solution was designed to improve transactional responsiveness while also delivering consistent, predictive performance.

To demonstrate the efficacy of this solution, we conducted testing looking at SQL Server 2014 TPC-C performance with Benchmark Factory. The test system configuration was kept simple, comprised of a single HPE ProLiant DL380 Gen9 server with a single 1.3TB SanDisk-based HPE PCIe Workload Accelerator and four HPE 8GB NVDIMMs.

Solution Overview

High Performance, Cost-Effective Acceleration

  • Single HPE DL380 Gen9 Server
  • Two Intel Xeon Processors
  • Four 8GB HPE NVDIMMs
  • Single SanDisk-based 1.3TB HPE Workload Accelerator
  • 128GB DDR4 Memory
  • HDD-Boot: two 500GB SATA Drives
  • HDD-DB: eight 1.2TB 10K SAS Drives
  • OS: Windows Server 2012 R2
  • Database: SQL Server 2014
  • FlashSoft caching software

Testing objectives:

We had two testing objectives:

  1. Measure TPS and Response Time for SQL Server 2014
  2. Compare the performance of an HDD hosted database in two scenarios: a baseline system operating without cache acceleration, and a system using FlashSoft cache-based acceleration with 4 HPE NVDIMMs (caching logs) and a single HPE PCIe Workload Accelerator from SanDisk (caching data).

The Result?

Baseline testing (with no caching and no acceleration):

  • TPS increased from 262 to 759 as the number of users and scale increased
  • But, response time increased from 0.2 to 9.99 seconds. Ouch!

Adding FlashSoft cache acceleration with NVDIMMs and flash:

  • TPS increased from 211 to 847 as the number of users and scale increased
  • But, response time decreased to 0.001 – 0.003 seconds!

Having a solution that leverages data caching for acceleration with in-server SanDisk Flash and HPE NVDIMMs is proven to be essential for optimal performance where response time is key for application workload performance.

Note that this solution also flexibly scales with users and can also be configured with additional NVDIMMs and SanDisk-based PCIe Workload Accelerators, as well as more servers to meet a range of workload needs.

The following graphs say it all:

SQL Server® Database Cache Acceleration Solution 1

Fig 1: Database on HDD with no Caching and Acceleration Benchmark Factory

SQL Server® Database Cache Acceleration Solution 2

Fig 2: Database on HDD with no Caching and Acceleration

SQL Server® Database Cache Acceleration Solution

Fig 3: Database on HDD with no Caching and Acceleration

SQL Server® Database Cache Acceleration Solution

Fig 4: Database on HDD with HPE NVDIMM Caching Logs and HPE PCIe Workload Accelerator Caching Data

SQL Server® Database Cache Acceleration Solution

Fig 5: Database on HDD with HPE NVDIMM caching Logs and HPE PCIe Workload Accelerator Caching Data

See us at Discover 2016!

Come visit us in booth #109 at Discover to learn more about this solution and our portfolio of flash-optimized HPE solutions that can transform your data center. Follow us live at the event @SanDiskDataCtr and share your comments below.

Accelerating the Department of Veteran Affairs

38 Million NOPM! Business Critical Performance on VMware All-Flash Virtual SAN

Subscribe Today!

Get our latest posts via email and enjoy data center insights in a flash