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
- 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
Be the first to leave a comment
You must be Logged on to comment or reply to a post.