How to find Expensive SQL Statements? How to solve?
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
Why do you use DDIC user not SAP* for Support Packs and SPam?
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 ?
what is the use of psapundo tablespace? what is the error ora -01555 represents.how can u prevent this error?
Is there any report or table in which user log off time is stored in sap?
What are the categories to execute sap background jobs?
i want my company code and controlling area defaut as 'ABC" through out SAP what to do ? and my plantcode also default to some value
What are the different types of sap profiles?
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 are the current support stack levels at market place?
What is the importance of table t000?
What are the different types of job status? Can you unschedule an active job?
A user moved the transport request from dev to qua. How would you trace him?
What are the regular activities u do in solution manager and how
Explain transport domain?
Can any one tell me some real time errors you got for support pack apply, During transport request export-import and for db dackup.