Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Posted Dec 23, 2009

Database Study Observes Performance Gains of Sun Storage F5100 Flash Array

By DatabaseJournal.com Staff

Recently, a comparison of performance for a DB2 database was done between a Sun Storage F5100 Flash Array and traditional hard disks. Both standard and advanced queries with complex logic was performed to observe any performance gains with the F5100 Flash Array.

From Shu’s blog, The testing environment was built using a Sun Fire X4275 server with two quad-core Intel Xeon X5570 processors and 72 GB of RAM to host the DB2 database server. The Sun Fire X4275 server runs the Solaris 10 OS (Update 8) and the DB2 UDB V9.5 Fixpak 4. Four SAS HBA cards installed in the database server to support the access to four array domains of the F5100 Flash Array, and up to 960 GB of raw storage (40 Sun Flash Modules). Host mirroring across HBAs and domains can be used to increase data availability, which reduces the usable capacity to 480 GB. The second SAS channel of two HBAs are connected to a Sun Storage J4400, which contains 24 x 146 GB disk drives. Two Storage I/O Modules (SIM 0 and SIM 1) are used with the J4400 to support dual-path. A Sun Fire X4200 is used as the workload driver with two duo-core AMD Opteron processors and 16 GB RAM. Two tests had the following results/benefits when using the flash array:

  • For complex joining, traditional disk registered 5629.60 total IOPs while flash/disk had 12983.86 IOPs—improving 3.2 times
  • For complex queries, traditional disk registered 6416.05 IOPs while flash/disk had 11345.43 IOPs—improving 77%
  • Query execution time, disk-only test was 1952 seconds while flash array had 180 seconds—improving 10.8

You can check out the full results in Shu’s blog entry to see how flash and disk technology can be combined to improve IBM DB2 UDB database performance

View Article

Daily News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.