Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22827 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
How you will rate yourself in SAP, Oracle from a scale 1 - 10?
Explain checkpoint?
Can anyone forward me EP faqs to the following mail id: hakeem99khan@gmail.com Thanks in advance
what is role of sap administrator in pi & ep?
Can you tell me about the landscape migration to cloud ?
What is business kpis ?
What are the DVD's Download for implementation?
When should we use Transactional RFC?
What is a background processing batch scheduler?
What is the use of commit value while deleting jobs in sap system?
What is an interface in SAP?
Where XML file is generated in solution manager?
What is the use of patches in sap system? Could you name few common patch types?
Is there a difference between user ddic and sap_all/sap_new?
Hi ,All What is the multi-threading and max connections for rfc. Actually i am facing problem while send large amount of idocs to external system using middle ware tibco r3 adapter. And how to enable these in SAP ?
