Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

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

Labels in this area