Database Monitor Tool

How To

The Database Monitor Tool is a separate user interface that may be accessed through the Tool menu of the JDBA Tool or through the Windows Start menu. Opening the Database Monitor Tool allows performance related statistics to be viewed on a graph that plots a statistical value on the Y-axis and time on the X-axis. Statistical parameters (or 'objects') to display on the graph are selected from a menu at the bottom of the screen. Each statistical parameter is sampled for a period of time, and the values are plotted on the x-axis. The scale of the graph determines the sample period. The Database Monitor Tool provides an interface to customize aspects of the view, including the following:

The Database Monitor Tool can track 34 different performance-related statistical parameters. The statistical parameters are summarized in Table.

Parameter

Description

Number of Transactions Started

The number of transactions started within the sample period.

Number of Transactions Committed

The number of transactions committed within the sample period.

Number of Transactions Aborted

The number of transactions aborted during the sample period.

Number of Checkpoints

The number of checkpoints that occurred within the sample period.

Number of Lock Requests

The total number of locks requested during the sample period.

Number of Deadlocks Detected

The number of deadlocks occurring within the sample period.

Number of Journal Block Reads

The number of journal blocks read from file within the sample period.

Number of Journal Block Writes

The number of journal blocks written to file within the sample period.

Number of Journal Record Writes

The number of journal records generated during the sample period.

Number of Journal Forced Writes

The number events within the sample period that flush dirty journal buffer to disk.

Number of Commit Waits

The number of transactions within the sample period waiting for group commit transactions.

Number of Logical Reads

The number of page/frame read events from the data buffer within the sample period.

Number of Logical Writes

The number of page/frame write events from the data buffer within the sample period.

Number of Physical Reads

The number of page/frame read events from disk within the sample period.

Number of Physical Writes

The number of page/frame write events from disk within the sample period.

Number of Index Page Splits Occurring

The number of index pages split within the sample period.

Number of Data Pages Compressed

The number of data pages reorganized within the sample period.

Number of Row to Page Lock Escalations

The number of events within the sample period causing escalation from row locks to page locks.

Number of Page to Table Lock Escalations

The number of events within the sample period causing escalation from page locks to table locks.

Number of Failed Events due to Lock Timeout

The number of events within the sample period that failed due to a lock time-out

Number of Events Waiting for Locks

The number of events within the sample period that were required to wait for the release of a lock on an object.

Number of SELECT Operations

The number of SELECT statements within the sample period.

Number of INSERT Operations

The number of INSERT statements within the sample period.

Number of UPDATE Operations

The number of UPDATE statements within the sample period.

Number of DELETE Operations

The number of DELETE statements within the sample period.

Number of SQLPrepare() Calls

The number of SQLPrepare() calls within the sample period.

Number of SQLExecute() Calls

The number of SQLExecute() calls within the sample period.

Number of SQLExecDirect() Calls

The number of SQLExecDirect() calls within the sample period.

Number of Fetches

The number of fetch operations within the sample period.

CPU Usage*

The average percentage of total CPU processing capacity experienced within the time period.

Peak Number of Connections

The maximum number of simultaneous connections occurring within the sample period.

Free Physical Memory (KB)

The average amount of free physical memory occurring within the sample period.

Total Swap Space (Bytes)

The total operating system memory swap space allocated on disk.

Free Swap Space (Bytes)

The total operating system memory swap space available on disk.

Table: Database Monitor Tool Statistical Parameters

*Windows 20 will only display the percentage of the first CPU in multi-processor systems. Monitoring a Database


Related topic:

Monitoring a Database