Reviewing transaction logs

The instance automatically logs the vital statistics of every transaction that it processes, and that information is available to you as an administrator. Reviewing transaction logs can help identify latency and performance issues.

To view the transaction log, log in to your instance and navigate to All > System Logs > Transactions.

To see the average response time of all listed transactions, select and hold (or right-click) the column Response time. Select Configure > List Calculations, and then select the Average value check box.

You can limit the list to those transactions that took place during the time period of interest. The default filter returns transactions from today.

Figure 1. Transaction log

For each completed transaction, available information includes the following (times are in milliseconds):

• Date/time, User ID, IP address, and URL of the transaction.
• Total response time, which doesn’t include the browser time because the server doesn’t have that information.
• Output length: how many bytes the transaction returned, after any compression.
• SQL time: time spent executing SQL commands.
• SQL count: number of SQL commands executed.
• Business rule time: time spent processing business rules.
• Business rule count: number of business rules executed.
• Network time: network transmission time, both from and to the user.

Note:

You can change which columns are shown and their order by selecting the Update Personalized List icon ()