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