The SAP In-Memory Appliance (SAP HANA) running on IBM 3850 servers can perform 10,000 queries an hour against 1.3 terabytes of data, returning results within seconds, according to a benchmark from WinterCorp.
According to SAP, the test scenarios were directly based on the query workload requirements typical in SAP customers' enterprise resource planning (ERP) reporting requirements. They accessed data found in the sales delivery database tables for the SAP ERP application. The test was part of a joint project between the two companies to deliver real-time analytics by optimising software and hardware, based on SAP in-memory computing technology and IBM's 3850 series servers.
Richard Winter, president and founder of WinterCorp, said, "In a review of the test specification, test runs and outputs, I find that the SAP HANA performance test is a valid determination of data warehouse query performance on in-memory test databases up to and including 4TB of realistically generated test data. The test data values are closely patterned after real SAP data, and the test queries are similar to operational and analytical business intelligence queries that occur in practice."
In the 1.3TB test, SAP In-Memory Computing technology was packaged with an IBM X5 server containing 32 cores, 0.5 terabytes of memory and a RAID 5 disk system.
Jake Klein, vice president for data and analytic engines at SAP, said, "The results of this performance test are one more important step for SAP and our hardware partners, demonstrating the significance of our in-memory computing technology to both the industry and our customers."