View Performance Information
To view transaction performance information:
- If you have not already done so, push the "Stop" icon to stop
the Real-Time Monitor.
- Select "Load Analysis" from the left-hand toolbar. Because Log
Explorer must read the entire transaction log to provide the analysis, you
must confirm before continuing.
- To identify the longest-running transactions found in the log, click on
the "User Load" tab in the Load Analysis screen.
- The four longest-running transactions are listed. You can right-click on
a transaction to browse to the detailed view of the selected transaction.
If you have run the real-time monitor demonstration, you will see that one
of the transactions has a duration of 4 seconds (4000 milliseconds displayed
in the last column.)
To identify heavily used tables:
- Click on the "Table Load" tab in the Load Analysis screen.
- View the number of Insert, Delete, and Modify transactions performed against
each table
Click 'Next' after viewing the Log Explorer Load Analysis.