IP-Maker Shows OLTP SQL Acceleration

IP-Maker, SAS, the NVMe start-up, showcased its new SQL acceleration demo at Flash Memory Summit, reaching 200,000+ transactions per minutes (TPM) on a low cost server, leading in an efficient performance/cost/power consumption configuration.

“We used to highlight the low latency IO/s of our NVMe technology in the past years, today we demonstrate the performance benefits of our NVMe technology in a data center application, providing more value for our customers,” said Mickael Guyard, marketing director, IP-Maker. “This example reaches more than 200,000 TPM, which is a great performance on such low cost server. The use of very fast NVMe drive for the logs eliminates the need of high cost server.”

Database is one of the most IO intensive applications. IP-Maker has deployed an OLTP example based on a low cost server running SQL Server 2016 and HammerDB using a TPC-C profile. The database file is located on a SATA SSD while the logs are located on the NVMe RAM reference design therefore removing the performance bottleneck on the logs IO/s. The NVMe RAM drive is designed with a hardware NVMe from IP-Maker integrated in a Xilinx Virtex 7FPGA. This architecture does not require any embedded CPU nor software to manage the NVMe protocol, leading in NVMe compliant 10µs latency range drive.