Interested to Buy Any Domain ? << Click Here >> for more details...
How to find Expensive SQL Statements? How to solve?
- 3 Answers
- 22888 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
Is it possible to install ecc 5.0 as a test system and not production, without installing solution manager?
what is garbage collector. is there any way to set the time to gc?
Which transport directory is used to implement support package and add-ons?
Mention the use of personalized tab and parameter tab in user master record?
I am installing a sap j2ee engine at crm. When it reaches phase 22 it halts for more than 10 minutes and gives up starting the system. What should I do?
How to setup RFC connection in ecc6 tells me steps involved?
What is GRIR, GRIR effect, why it is imp, How it is analysed, What is expected out GRIR, What is auto write off & Manual GRIR write off?
How to assign a mass Tables in Auth Group by using T-code:se54
Is it possible to install sap patches when other users are online?
What is the different architecture between SAP 4.7EE & ECC5.0
I also wanna work with Webdynpros? What are the requirements? I mean SAP 4.7 ee or ECC 5 or 6? Netweaver developer Studio? Also with win 2003 i have the activation problem every month. SO do i get a cd that doesnt ask for the activation? i have win 2000 but can it be installed on HP pavilion laptops that are coming preinstalled with Vista OS?
What are the key responsibilities of sap basis administrator?
How to apply java stacks ? expalin step by step prcoess
If any errors coming during transport where it will be recorded and how will you rectify?transport log and active log
What is an ‘ok’ code? What are the differences an ‘ok’ code to a ‘t-code’?
