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 |
Mention what is the difference between central instance & application server?
Is there any report or table in which user log off time is stored in sap?
How do you create a password exception list?
What is organization level ?
What are common transport errors?
Can anyone help me in educating me in installing SAP 4.6C over windows server 2000. Please make it a step by step process, my career depends upon the success and failure of installation.
How do you do the load balancing?
how do you troubleshoot when user complains that he is not getting login screen?
Can anyone tell me How to lock a single client from sap level and from o/s level?How to lock users from o/s level.
If multi log on parameter value is:1". one GUI user logged in one terminal, and same user id logged on other terminal as GUI, It will ask for Terminate a session if User selected to Terminate it will not to be terminated in SAP
2 Answers Willsys Technologies,
Why is java Required while installing SAP
how to find whether the operating system is 32bit or 64bit in SAP Level and O/S Level?