how to see sql queries for interactive app ?

[cncjay]

Hello All,

In have a need to see the SQL queries being issued by an interactive application. Our contract developer has created an application, in launching, it seems to take close to a minute before it opens. It is quite possible the table(s) it is going after, they are missing indexes since I'm dealing with a custom app.

Can anyone provide some steps in going about doing that. We are on SQL2008R2, JDE E1 9.0 Tools 8.98.4.10.

Any help is greatly appreciated.

 

[cncjunior1]

Start the session in debug mode for the user and you will see all the SQLs generated. If the SQLs are being called from a BSFN then you will need to turn the call object kernel the person is connected to in debug mode as well. You could use your database tools to then see if there are any indexes that could be build for the SQL that may help.