This report describes the certification of Sybase Adaptive Server Enterprise version 15.7 (hereafter called “ASE”) with Violin Flash memory-based storage arrays. The Flash arrays were utilized for all the database devices.
Violin Flash Memory Arrays are specifically designed for extremely high, sustained performance with reliability and serviceability. Violin’s flash-based appliances scale to hundreds of terabytes of capacity, millions of I/O’s per second, and gigabytes per second of bandwidth. They are orders of magnitude faster than disk-based arrays. Violin 6000 Series arrays bring storage performance in balance with high-speed computing and networking and offer a significant opportunity for infrastructure consolidation. Flash memory technology is increasingly being utilized in today’s mission-critical and high-performance enterprise systems
This section describes the environment utilized for the certification. Although this certification was done on Linux running on Intel CPUs, any hardware/software combination, which is supported by both ASE and Violin, is certified.
Fiber-Channel Connectivity Layout
Violin 6616 Memory Array
OLTP Test Driver Installation:
Backup/Recovery Test Driver Installation:
There were two overall sets of testing:
The OLTP testing simulated an order-entry environment that represents real-life business activities in order placement scenarios. It covered operations like new order placements, entry of customer payments, checks on order status, directives to fulfill shipment for orders placed and queries on updated inventory levels. Close to half the total number of transactions were new incoming orders. Transactions included processing, concurrency control, logging and various DML and database query operations.
The OLTP Test was done independently on three different ASE device configurations:
In addition, each OLTP test was performed independently with an ASE 4k page size and ASE 16k page size.
Database backup and recovery testing was performed to insure database consistency after backup and restore.
Sybase provides a site dedicated to the Sybase ASE product. On this page, there are links to Data Sheets, White Papers, Webcasts, Podcasts, News, Case Studies (customer success stories), Events, Analyst Reports, Videos, Awards, and Newsletters. There is also a link to download a trial of Sybase ASE.
The Sybase ASE Resource page is located at: http://www.sap.com/solutions/technology/database/adaptive-server-enterprise/index.epx
Vendor Name: Violin Memory
Web Site: http://www.violin-memory.com/