Transaction Processing

Tier 1 databases deployed to support OLTP workloads are characterized by many small, interactive transactions that generally require sub-second response times. Often these database applications are mission critical to the operations of a business and are central to the speed that orders are processed, services are delivered or decisions are made. Application Administrators are under tremendous pressure to meet Service Level Agreements (SLAs) for availability, performance and cost since all these factors can impact the performance of a business in today’s highly competitive landscape.

Database applications such as MS SQL Server, Oracle or MySQL have high concurrency requirements and are often plagued by I/O performance issues inherent with traditional hard drive-based storage systems. Most IT admins attempt to resolve OLTP performance challenges through tuning and indexing of the database or by throwing more storage hardware resources as the problem. But a rip-and-replace approach can be both disruptive and highly expensive and may in the end not effectively resolve the performance challenges.

Figure 2 OLTP SB

Figure 2 above depicts an OLTP lab experiment with various modes of CacheAdvance acceleration utilizing Windows Server 2012, MS SQL Server 2012 and Micron’s P320h PCIe solid state drive (SSD). In the pure HDD test run, the system delivered 41 TPS, but when that same database was accelerated with the CacheAdvance generic optimization and Micron’s P320h SSD the system delivered 70 TPS, a 71% improvement. Further, when the PrimaryIO APA for MS SQL Server was utilized the system delivered 222 TPS, an improvement of 441% over pure HDD.

Specs & Requirements

Components PrimaryIO Core, Web GUI and Application Performance Acceleration plug-in for MS SQL Server, Oracle Database and MySQL

Cache Type Fully Associative Cache

Cache Mode Write-through, Write-back, Write-around, Read-around

Cache Size Maximum 1 TB

Management GUI, CLI

Operating System 64 bit x86 Linux, Microsoft Windows 2008/2012

Environment Baremetal, VMWare, KVM, Xen, AWS/EC2

Ram 40MB minimum for optimal performance

Processor Two dual-cores Processor 2.2 Ghz or more

Supported SSDs SSD supporting PCIe, SAS or SATA interface