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 are the port nos of Dispatcher,Gateway, Message Server, Printer in windows,niping,Router ?
Explain Local Client Copy ?
What is the different architecture between SAP 4.7EE & ECC5.0
what is data dictionary objecst?
whats is happening in post import processing in scc7?
1 Answers HCL, Vikalp Solutions,
What are the different types of sap profiles?
How to get a transaction history of a user for a period of 6 months? I also wish to know if we can take the report month wise by specifying start and end date.
What are the functional modules used in sequence in BDC?
What is the difference between SDM and JSPM?
What are the different modules of SAP?
What to do if If Buffer Hit ratio is less than 95%
What is supplementation language?