HPlogo ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems

Chapter 1 Basic Concepts in ALLBASE/SQL Performance

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

Before presenting specific tips and tricks for tuning your DBEnvironments, this chapter presents some information about how data is passed about in ALLBASE/SQL among files, buffers, applications, and other elements in a typical large-scale production environment. The following topics are included:

  • DBEFile organization.

  • Data Buffering.

  • System Catalog.

  • Log File Organization.

  • Log Buffering.

  • Locking and Latching.

  • Sorting.

  • Optimization.

  • Sections and Validation.

Before reading on, you may wish to review the material found in the "Physical Design" chapter of the ALLBASE/SQL Database Administration Guide and the "Concurrency Control" chapter of the ALLBASE/SQL Reference Manual.

Feedback to webmaster