April 22, 2020
Estimated Post Reading Time ~

Request Log Analyzer to find the top 10 expensive queries in AEM 6.4

Statement: Analyzes the current request log in order to identify the most expensive requests in a given period.

Solution:
Go to this path http://localhost:4502/etc/reports/healthcheck.html
Enter the below details as per screenshot
- The last number of hours from now to be analyzed - Enter the hours since when
- Limit output to the specified number of lines.
- Analyze up to the specified number of requests (-1 meaning all)



You can run the request log analyzer on daily basis to check the expensive requests and have automated mail alert to email box , Make sure SMTP is configured to receive the mail alerts of the request log report
Also you can configure the run time of script on daily basis for autorun and get the automated email.
Below screenshot shows the top expensive queries and further you can investigate on these queries as required



If you don't configure the SMTP and trying to configure your email id for auto alert. you will see the below error. make sure SMTP is configured.


Request to Analyze 10 request for the first 1 hour as show in the below screenshot.


By aem4beginner

No comments:

Post a Comment

If you have any doubts or questions, please let us know.