View Performance Information

To view transaction performance information:

  1. If you have not already done so, push the "Stop" icon to stop the Real-Time Monitor.
  2. 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.
  3. To identify the longest-running transactions found in the log, click on the "User Load" tab in the Load Analysis screen.
  4. 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:

  1. Click on the "Table Load" tab in the Load Analysis screen.
  2. View the number of Insert, Delete, and Modify transactions performed against each table

Click 'Next' after viewing the Log Explorer Load Analysis.