PRO+ Premium Content/Storage

Thank you for joining!
Access your Pro+ Content below.
Vol. 1 No. 12 February 2003

Optimize database storage

Editor's Note: This is an excerpt of a three-part article written by Jim Booth for Storage magazine's February 2003 issue. To view the complete text and graphics for this article, click on this link. (Or, if you have not yet signed up for your free subscription to access Storage magazine content, you can do so from the following, online subscription link.) The movie "Father of the Bride" contains the song "Give Me the Simple Life," an old adage that can be aptly applied to database storage. Sometimes it's the simple things that offer the greatest impact. This article explores data placement issues regarding different kinds of database objects and their I/O characteristics. Once we know the type of objects being used and the access methods for each object, we can begin to optimize the database storage environment. This will require examining the different types of storage devices available and how each storage component can affect the I/O performance on our database. Storage class, channel connectivity, levels of availability and...

Access this PRO+ Content for Free!

Features in this issue

  • Midrange Arrays Inherit High-End Smarts

    Virtualization layers, once a feature of only the most expensive storage subsystems, are beginning to ship with midrange storage systems.

  • Optimize database storage

    by  Jim Booth

    In this article, author and consultant Jim Booth maintains that different database objects may each require their own type of storage to make the database operations run more smoothly. Whether you're dealing with tablespaces, indexes, redo logs or archives -- there's a right and wrong storage choice for each database component. This article explains what they are.

  • Inside the new Symmetrix

    by  Michael Desmond

    Inside the new Symmetrix

Columns in this issue