Skip to Content
Technical Articles
Author's profile photo Qiansheng Wang

The new features of the enqueue log analyzer

The enqueue log analyzer is a lightweight Java tool used to analyze the SAP enqueue logs. It provides answers to common Enqueue problems and saves your time during root cause analysis for Enqueue issues.

In this blog post, I would like to share the new enqueue log analyzer (KBA 2763999) features with you. Many new functions are introduced since the first release in 2019, and I will show the following important features one by one.

    • The new version supports the new format of ENSA2.
    • The new version can create an analysis report which could be shared easily and will improve the collaboration (e.g. between basis and application colleagues).
    • The new version is more intelligent.

Support ENSA2

The new version supports the new log format of “Standalone Enqueue Server 2“. The ENSA2 log can be activated via “Request Trace” in SMENQ and is saved on OS level with the name “enq_requests.dat”. We could simply drag and drop the ENSA2 log into enqueue log analyzer, and it will be analyzed the same as the ENSA log.

Create an Analysis Report and Share It with Your Friends

The analysis report is a simple local HTML file that could be shown in any browser. After the report is created or saved, it could be shared with other people in any way, e.g. an email attachment. Because the report summarizes and aggregates the useful information from both the application’s perspective and the view of the enqueue itself, it will improve collaboration between your customers, colleagues, or friends. For example, if you work in the BASIS area, it will be very handy to share this report with the application experts and discuss with them based on the report instead of the enqueue log.

The following screenshot is an example of what the report looks like.

The analysis report could be created via the “Open Report” button in the GUI or the command line below.

    • java -jar EnqueueLogAnalyzer.jar -s <source-file> -d <destination-directory> -f <report-filename>
    • The “Open Report” button in the GUI.

The new version is more intelligent

Besides supporting ENSA2 and improving the collaboration by the analysis report, the most important change in this release is that the enqueue log analyzer is more intelligent. Now it can not only tell us how many rejects happened on which lock object but also show us the following conclusions.

    • Who held the expensive locks and caused the rejects.
    • Who triggered the rejected requests. It is the same user with the lock holder?
    • Are most of the rejects blocked by one transaction, one user, or several transactions from several users?
    • Did the rejects happen on one lock arguments or several expensive lock arguments?
    • How long the lock is held. Is the lock period short, or too long?
    • Is there any hint that which expensive transaction should be checked?
    • Is there any hint that the symptom is a parallelization issue or concurrency issue?

All the answers could be found in the “Analysis Summary” part in both the HTML analysis report (e.g. the screenshot in the previous part) and the GUI (e.g the following screenshot). One tip is to pay attention to the bold or the blue part while reading the analysis summary.

Summary

In summary, the new version is able to support ENSA2 log format, create an analysis report to improve the collaboration, and provide a more intelligent diagnosis. So it is worth downloading the new version here(1.0.20210125) and trying it.

At last, please feel free to send me a message or write a comment here if there is any feedback. Thank you very much.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Tom Wan
      Tom Wan

      It looks good, thanks for sharing

      Author's profile photo Sri Krishna Chaitanya
      Sri Krishna Chaitanya

      unable to download the tool. could you please update the link.

      Author's profile photo Qiansheng Wang
      Qiansheng Wang
      Blog Post Author

      Hi Sri Krishna Chaitanya,

      Thank you very much for your interest in enqueue log analyzer.

      I am not sure whether it is some temporary issues with the SCN download. Would you please try the download again to see whether it turns to the same error? If so, would you please forward the error message or the SCN download notification email to me?

      Thanks very much. Have a nice day.

      Best regards,
      Qiansheng Wang