Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 23042 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
Where can you find a list of object keys included in a transport?
How you can disable the ‘import all’ button on stms for the queues?
Have you done any up gradations?
before doing client copy you have to adjust table space at os level.what is the single command for that?(with out going through all the menu of brtools)
What is development class? Why to create the development class?
What are the categories to execute sap background jobs?
please share sap basis admin interview questions .. thanks sadik
What is an interface in SAP?
How database extend?
How to deactivate IPC in standalone CRM.
how can i change access to a user who is having access for SPRO display only to change access in sPro
What is an “ok” code is and what is the difference between “t-code” and “ok” code?
Which transaction do you use to check buffer statistics ?
How many types of work processes are there in sap ?
Explain what is business kpis ?
