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
- 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.
- 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