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 |
the end user was facing performance problems.how can u trouble shoot this?
How to change default password of EARLY WATCH STEP BY STEP
How to Upload and Downloading of roles?
you want to take sap backup using brtools. How would you do that?
What do you mean by Transport domain?
I have created a role for user. Now i want to unauthorize to user for particular TCODE. Now, what i'll do for this?
What are the different modules of SAP?
Is there a way to perform sapgui 640 roll out using a centralized server?
hi... 1) i have 100 rfc connections on my target system. now i am performing system refresh..... do i recover all these connections using import export method or do i need to take screen shot of each rfc and create again after refresh. 2) if i delete any rfc in abap engine, do dis event writes into log if yes may i know how to check dis log file
Suppose one A User has tcode SU01.When A try to execute tcode su01,not able to execute.but next day User A can able to execute the same tcode SU01. Which not done user comparision next day too but how come User A can able to execute tcode SU01?
How to do client copy?
What are steps for DB Refresh?
0 Answers Anmol Biscuits, BAL,