How to find Long running query running in TREXADMIN

This article will help you to monitor long running query running in TREXADMIN

This  symptoms of long running query can be one of the cause for portal query running slow

1. In TREXADMIN transaction enter the RFC and execute :-

   b Click on Advanced Mode Tab.. Below screen will appear

c) Click on Thread Tab

d) Check for the duration Tab and see if any query is running for long duration.

1. If you want to check who has run the query , You can login in Trex Admin Tool and see who has requested a hanging request for long duration in Services–>Threads Tab

            Contact the User to check the operation and status of this request and take corrective action

Thanks & Regards

Amit Shedge