AEM Common_How to identify Slow running Queries.

Solution1: To identify the slow running queries.

1.       Download the Jar file of relevent Oak version of AEM server

https://files.acrobat.com/a/preview/8216d8ac-1367-4960-a200-6622d7044051

2. Execute the jar file from terminal/command prompt using below command 

java  -Xmx1024m -jar qla.jar

1.       Example for file at location "/adobe/ToolsDailyUsage/cq6/author/crx-quickstart/logs/error.log" the command is 

 java  -Xmx1024m -jar qla.jar "/adobe/ToolsDailyUsage/cq6/author/crx-quickstart/logs/error.log"

2.       The output of my instance is shown below