HP.com home ALLBASE/SQL Performance and Monitoring Guidelines: HP 9000 Computer Systems > Chapter 6 Getting Started With SQLMON

Navigating SQLMON Subsystems

» 

Technical documentation

/td>
Complete book in PDF
» Feedback
 

 » Table of Contents

 » Index

SQLMON has six subsystems, which are listed below:

  • Overview, which shows general performance information

  • IO, which provides information on data and log buffer activity

  • Load, which displays transaction throughput data

  • Lock, which shows locking activity

  • SampleIO, which provides information on DBEFile, table, and index I/O

  • Static, which describes indexes, tables, DBEFiles, and constraints

The name of a screen identifies the subsystem to which it belongs. Each subsystem has a primary screen, with the same name as the subsystem, and secondary screens, whose names begin with the subsystem name.

When you access a screen, you automatically move to the subsystem that screen belongs to.

Figure 6-1 “SQLMON Road Map” shows how the SQLMON screens and subsystems are organized.

Figure 6-1 SQLMON Road Map

[SQLMON Road Map]