Storage Focus: Databases and Storage Architecture -

Storage Focus: Databases and Storage Architecture

Download the authoritative guide: Enterprise Data Storage 2018: Optimizing Your Storage Infrastructure

All too often I have seen the process of determining what storage and configuration settings should be assigned to a database become a completely disjointed process. The database architect is typically a database expert and knows little about the low-level details of storage configuration. Combine this with the fact that the storage administrators and architects often know little about how the database will use the underlying storage and what the requirements and best configuration are for the database, index files, the log files, and of course, the file system and volume manager.

This typically results in an inefficient use of storage resources that can increase the overall cost and reduce the performance to a point where you might not be able to meet your requirements. Add to this the ever looming budget and the fact that management needs things to work efficiently with the available budget. This article will address some of the issues that DBAs and storage architecture must work together on when addressing the architecture problems.


The hardware and software requirements for end-to-end storage architecture for most databases are:

  • Database

    • Control files
    • Table space
    • Index files
    • Redo logs

  • Operating System

  • File system and volume manager (this may not be relevant if the database runs on a raw device)

  • Host bus adapters (HBAs)

  • Storage hardware

Each of these areas has multiple components, features, and functions that can have a significant impact on the overall performance.

Page 2: Database

Page 1 of 5

1 2 3 4 5
Next Page

Comment and Contribute


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



Storage Daily
Don't miss an article. Subscribe to our newsletter below.

By submitting your information, you agree that may send you ENTERPRISEStorageFORUM offers via email, phone and text message, as well as email offers about other products and services that ENTERPRISEStorageFORUM believes may be of interest to you. ENTERPRISEStorageFORUM will process your information in accordance with the Quinstreet Privacy Policy.

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.
Thanks for your registration, follow us on our social networks to keep up-to-date