Quantifying the benefits of using EMC Enterprise Flash Drives in DB2 9.7 for Linux, UNIX, and Windows OLTP environments

How OLTP workloads perform on EMC Enterprise Flash Drives compared to Fibre Channel hard disk drives

From the developerWorks archives

Roger Sanders

Date archived: January 13, 2017 | First published: April 29, 2010

Flash drive technology, also referred to as solid state drive (SSD) technology, was introduced more than three decades ago. However, until recently, the high cost-per-gigabyte and limited capacity of these drives restricted deployment to niche markets or military applications. But recent advances in Flash drive technology and economies of scale have driven down the cost, and have made Flash drives a viable storage option for many I/O-intensive enterprise applications.

With EMC's addition of Flash drives to Symmetrix storage arrays, organizations can now take advantage of ultra-high performance, optimized for the highest-level enterprise requirements. Flash storage is ideally suited for applications with high transaction rates and those requiring the fastest possible retrieval and storage of data, such as on-line transaction processing (OLTP) applications.

This article examines the performance of an OLTP workload with an IBM® DB2® 9.7 for Linux®, UNIX®, and Windows® database on Flash drives versus conventional hard disk drives. It also provides information on how you can integrate Flash drives into your storage infrastructure so you can immediately take advantage of this technology to improve database performance and increase productivity.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=485760
ArticleTitle=Quantifying the benefits of using EMC Enterprise Flash Drives in DB2 9.7 for Linux, UNIX, and Windows OLTP environments
publish-date=04292010