Premium Content

Access "Optimize database storage"

Jim Booth Published: 16 Oct 2012

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 overall performance are all ... Access >>>

Access TechTarget
Premium Content for Free.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

What's Inside

Features
    • Snap Hints at Next-Gen NAS

      In short order, you won't have to worry about whether to buy NAS or SAN storage.

    • Storage SLAs--get ready by Carol Hildebrand

      Separating storage from servers means separate SLAs, too. Here's how to build one that can help control costs and manage service levels.

    • SCSI Drives Bow Out of Capacity Race

      For the first time last year, it became possible to buy an ATA disk drive with more capacity than a SCSI drive.

    • Caches with the Write Stuff

      Do you think that collaborative file creation, editing, storage and management between geographically distributed users is a pipe dream?

    • Veritas Dumps Bare Metal Restore for TSM

      Veritas has announced that effective this June, it will discontinue sales of Bare Metal Restore for IBM's Tivoli Storage Manager.

    • 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.

    • Types of Block Data Replication

      All block data replication schemes are not created equal.

    • Virtualization in the switch? Not so fast by Marc Farley

      Before you buy into the whole intelligent switch hype, consider that some intelligence is best placed elsewhere.

More Premium Content Accessible For Free

  • Big data storage challenges: Speed, capacity and HDFS integration
    big_data_hadoop.png
    E-Handbook

    Big data infrastructure and analytics are some of the hottest technology topics today, and it can sometimes seem impossible to dissect and digest all...

  • Moving target: Endpoint backup
    storage_0814.jpg
    E-Zine

    Mobile workers are now accessing, creating and modifying data on ultra-portable devices such as smartphones, tablets and phablets. Most companies ...

  • A lesson in flash caching
    storage_0714.png
    E-Zine

    Solid-state storage is proliferating as a replacement for hard disk drives, where it offers a quick shift into the fast lane of storage processing. ...