JMX bean for finding slow running queries | Community
Skip to main content
Level 4
March 13, 2016
Solved

JMX bean for finding slow running queries

  • March 13, 2016
  • 2 replies
  • 964 views

In 6.1, I can't find the JMX bean so i could use the following URL that used to list the slow running queries

/system/console/jmx/com.adobe.granite%3Atype%3DQueryStat

Is there another bean in 6.1? Secondly can you list the classes I should add to sling logger to list slow running queries and in general queries that are running against the isntance?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by kautuk_sahni

Hi

Apart from what Scott has mentioned, please have a look at following KB articles for your help:-

Link 1:- http://blogs.adobe.com/experiencedelivers/experience-management/how_to_find_longrunningqueries/

// It covers How to find long running queries.

Link 2 :- https://helpx.adobe.com/experience-manager/kb/AnalyzeSlowAndBlockedProcesses.html

// Analyze slow and blocked processes

Link 3 :- https://helpx.adobe.com/experience-manager/kb/BoostInSearch.html

// Use Boosts | Indexing time and query runtime

 

I hope this will help you.

 

Thanks and Regards

Kautuk Sahni

2 replies

smacdonald2008
Level 10
March 13, 2016

Here is a 5.5 KB that talks about this subject: 

http://blogs.adobe.com/experiencedelivers/experience-management/how_to_find_longrunningqueries/

Notice it mentions the QueryStat under JMX tab. This option is still present in AEM 6.1. Look under the Main menu in the Felix console. 

Hope this helps. 

kautuk_sahni
Community Manager
kautuk_sahniCommunity ManagerAccepted solution
Community Manager
March 14, 2016

Hi

Apart from what Scott has mentioned, please have a look at following KB articles for your help:-

Link 1:- http://blogs.adobe.com/experiencedelivers/experience-management/how_to_find_longrunningqueries/

// It covers How to find long running queries.

Link 2 :- https://helpx.adobe.com/experience-manager/kb/AnalyzeSlowAndBlockedProcesses.html

// Analyze slow and blocked processes

Link 3 :- https://helpx.adobe.com/experience-manager/kb/BoostInSearch.html

// Use Boosts | Indexing time and query runtime

 

I hope this will help you.

 

Thanks and Regards

Kautuk Sahni

Kautuk Sahni