How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 21897 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is the importance of table t000?
Hi, Cansomeone please send the system refresh doc , it's very urgent for me. Thanks in advance.
If you have a long-running Job, how do you analyse?
Have u applied patches what is the transaction code?
Explain how you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
what is the difference between with core
What is an interface in SAP?
What are the different user types in sap system that an admin can use while creating a new user?
How to do transport at OS level?
what is your project architecture?
how to do system refresh?not the client copy but the-standard-system-refresh.
How you can restrict multiple logins of user in sap? What are the thing you have to take care of while writing the id’s?
How will u send mail after completion of backup?
Explain the system log?
does the Tcode EWZ5 exist in ECC6?I'm using NW2004S SR2 abap engine and EWZ5 doesn't exist in that.so in that case what is the alternative to EWZ5?to see the list of users present in a client but not necessarily logged in and to to lock or unlock them? Thanks.
