0

MarkLogic 9.0.8.2

We would like to see the long running queries on MarkLogic App Server.

We were looking at documentation and this link

This knowledgeable talks about running "appserver-status.xqy" in qconsole to generate report on queries running currently.

What we need to know is list of long running queries in the last month and then investigate on how we can improve it.

Is there any way we can extract these information?

Jonathan Hall
  • 75,165
  • 16
  • 143
  • 189
Manish Joisar
  • 1,256
  • 3
  • 23
  • 47
  • 1
    The data from that script is not persisted, so you would need a mechanism to schedule it to run periodically, and to persist the data. You could alter that script, or you could upgrade to a more recent release and use [Request Monitoring](https://docs.marklogic.com/9.0/guide/performance/request_monitoring) which will log requests. – Mike Gardner Jun 23 '20 at 23:13
  • Hello MG, Thanks for your reply, So upgrading to 9.0.12 will start logging App request monitoring ? – Manish Joisar Jun 24 '20 at 05:55
  • 1
    Not automatically, but the feature is available if you perform the steps in the documentation. – Mike Gardner Jun 24 '20 at 18:57
  • Thanks MG for your reply, Can you please post as a answer, i will then Mark it. – Manish Joisar Jun 25 '20 at 06:09

1 Answers1

1

The data from that script is not persisted, so there would need to be a mechanism to schedule it to run periodically, and persist the data. You could alter the script, or you upgrade to a more recent release and use Request Monitoring.

The process to enable Request Monitoring is in the documentation, and once it's enabled, the requests will be logged in the app server RequestMonitoring log.

Mike Gardner
  • 6,611
  • 5
  • 24
  • 34