Performance Analysis Tools

The performance analysis tools can be used by system administrators and others to determine the users and processes that are affecting system performance. These tools are primarily database tools; they display the total number of reads, writes, and accesses to a database either by user or by database table. There are two basic types of tools:

• Reports. The Table Statistics Report, Index Statistics Report, and User Statistics Report list the number of reads, writes, and accesses to a table, index, or by a user since the database was started.

• Interactive Tools. The User Statistics and Table Statistics interactive tools display the number of reads, writes, and accesses to a database within a time period (for example, the last 10 seconds), by user or table.

These tools are based on Progress VSTs (Virtual System Tables—see your Progress documentation for more information on VSTs). The tools can help you analyze system performance issues. For example, if subscriber payment processing is taking an unusually long time, you could run the Table Stats tool to see how many records are being written while it processes, and what tables are involved.

Reports

There are three reports that can be run to analyze system performance:

• The User Statistics Report lists the number of reads, writes, and accesses to one or more databases by the current sessions. Each session’s user name is listed, and the sessions are listed in order of total number of accesses (with the highest users at the top of the report). The report can be run in detail mode (each database broken out separately) or in summary mode (only one line for all databases).

• The Table Statistics Report lists the number of reads, writes, creates and deletes that have been made to each table in one or more databases since the database was started. The report can list tables alphabetical by table name, or in order of reads (with the tables with the most reads at the top of the report).

• The Index Statistics Report lists the number of reads, writes, creates and deletes that have been made to each index in one or more databases since the database was started. The report can list tables alphabetical by index name, or in order of reads.

All of the reports have the standard view/print options.

Example—User Statistics Report

Example—Table Statistics Report

Example—Index Statistics Report

Interactive Tools

The interactive tools give a snapshot of what is going on in the system between regular time intervals. There are two interactive tools. The User Statistics tool displays the reads, writes, and accesses for the top users within a given period of time. The Table Statistics tools displays the same thing, but for tables rather than users.

When running either of these tools you must define:

• Whether users should be sorted in order of the number of database writes, reads, or accesses. With tables, the sorting can be in reads, updates, creates or deletes.

• The number of users (or tables) displayed.

• Whether to update the display and, if so, the time interval (in seconds) at which the display is updated.

• Whether the number should be the number of reads, writes and accesses since the tool was started (cumulative) or since the display was last updated.

Once started, the tool will display the top users or tables. If run with Repeat = “y”, the screen will update every fifteen seconds (or whatever time period you entered in Every).

To exit from the interactive tools, press F4.