Skip to Content
avatar image
Former Member

Viewing Currently executing SQL statement using SAP transaction

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Aug 21, 2007 at 10:36 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 10:28 AM

    hi

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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Aug 21, 2007 at 11:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded