Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22675 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 do you create an instance?
When I check transaction sm37 and I want to see the spool I get a message that says "no list available." Why is this?
When should we use Transactional RFC?
Do you know about oss what do you do with oss?
Explain what is the purpose of tdevc ?
Explain the developer trace?
How to identify a particular T_Code has been modified or not? If yes, how to identify who modified particular T_Code in current system?
what is the use of tcode SUSHARE in SAP and how the mass user authorizations compared?
Explain kernel upgrade?
How do you distribute the load?
How to assign a mass Tables in Auth Group by using T-code:se54
Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?
Differentiate between synchronous and asynchronous transport
Myself Rahul am MBA(Mkt)having 1.5 years marketing experience.and in SAP-SD for 1 years experience.am looking for job.so pl anywher opening then pl let me revert.
What is luw (logical unit of work)?
