Viewing Currently executing SQL statement using SAP transaction

[Former Member]

Hi techies,

I want to know how can we view currently executing SQL Statement in SAP?

I wanted to know the transaction from which I can view this.

Scenario: A Dialogue process or any process for this case, is running a report or any module for a longer period of time, I want to know which SQL statement is causing the late running of the report or module.

Regards,

Suresh

[Former Member · Accepted solution]

If you want to see a SQL request that runs too longer or his consumption of memory is big then you can go to ST04 transaction and "Detail Analysis Menu" and "SQL request".

You can here see the SQL request and too many other data.

Regards.

[Former Member · Accepted solution]

Thanks Albert,

I was able to catch the SQL query with your suggestion

[Former Member]

hi

when u click the dialog process that is running the report it will definitely show the

sql statement (one column as LAST SQL STATEMENT in that u can get the query)

i think u are clicking the idle process and checking there u will not get the sql statement

[Former Member]

hi

u r monitoring long running process in SM51 only know then double click on that process u will get the sql statement running

[Former Member]

Thanks a lot Dinesh for your reply.

When I double click the process which is running, it just gives only the detail display of the process only and not the SQL statement. It shows the table which it is accessing and what process it is doing in the table (ex. sequential read), but do not show the exact SQL query it is executing.

Please advice