How to find Expensive SQL Statements? How to solve?
Answers were Sorted based on User's Feedback
Answer / inder09
Using ST03N Choose the Standard Transaction Profile in
transaction ST03N and restrict the display to task type Dialog.
Sort the Average DB time (ms) column in descending order.
Transactions with high average DB request times might be
caused by expensive SQL statements.
Sort the Total Database Time column in ascending order. Then
Total this column. Transactions causing more than 5% of this
total database time are worth a closer look with respect to
tuning measures.
Sort the Total Response Time column in ascending order. Then
Total this column. Transactions causing more than 5% of this
total response time are worth a closer look with respect to
tuning measures.
Using the Database Monitor ST04
The quality of the database data buffer should be higher
than 90%.
Check the number of user calls compared to recursive calls.
There should be less recursive calls than user calls.
Check the Reads/User Call. If this value exceeds 30(blocks
read per user call) then this is a strong indicator for
expensive SQL statements
Is This Answer Correct ? | 12 Yes | 1 No |
Answer / venkat
To find expensive sql statement.
Goto DBACOCKPIT ->performance->SQL statement Analysis->shared cursor cache [sap net weaver]
Goto ST04 -> Detailed Analysis Menu -> SQl Request -> Sort by disk reads/ buffer gets / executions.
goto ST05 and find out the sql statements whic consumes more than are around 50000 records are reads.
you have to work with DBA people to finetune them
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rout
U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.
Is This Answer Correct ? | 5 Yes | 4 No |
what will you do when you cannot login to a dialog server ?
i have t-code su01 in crm and r3 in a financial org.i can create sap ids , unlock /lock sap ids , assign t-code, roles & assignment to users . what else can be done ? more importantly am i eligible for a job in sap basis since i am doing this job for last 2 years ?
Where will u find transport error logs?
What happens when there 2 enqueue in R/3 system ?
What do we mean by Table spaces in BAsis , How many type of table Table spaces ?
what is transaction to acess the language utility?
Are you worked on EP? What are the activities are having related to Sap-basis can any one tell me what are the roles?and how will work on that one
how to change the owner of a file in unix
How to add sap router entry into sap gui logon pad.
How to define logon groups?
Explain ECC 6 Installation steps in brief?
What are the activities you done in PI?