Disk Layout Terminology and Examples

The main purpose of any database server tuning effort is to eliminate the performance hot spots or bottlenecks in the disk and network subsystems. A well-balanced database server's performance bottleneck should be, in the ideal world, its processors and memory architecture, not its disk or network I/O subsystem. Theoretically, more disks and faster network cards can always be added until at some point the server runs out of processing power.

Up to now, the basics of storage system technologies have been covered in this chapter. Deciding on the minimum amount of disks and disk I/O controllers has also been covered. The remaining focus is on the layout of the files typically contained in a database server for ...

Get SAP Hardware Solutions: Servers, Storage, and Networks for mySAP.com now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.