How to find Expensive SQL Statements? How to solve?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / venkat
To find expensive sql statement.
Goto DBACOCKPIT ->performance->SQL statement Analysis->shared cursor cache [sap net weaver]
Goto ST04 -> Detailed Analysis Menu -> SQl Request -> Sort by disk reads/ buffer gets / executions.
goto ST05 and find out the sql statements whic consumes more than are around 50000 records are reads.
you have to work with DBA people to finetune them
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rout
U can find expensive SQL statements using T_code:ST05 /SM50
U can solve this either by killing the process or find out
the table that has been accessed adn creat some indexes ,so
that it can be accessed easily or get the workload
statestics information and tune the system.
Is This Answer Correct ? | 5 Yes | 4 No |
2. What is Kernel dependent and independent in Sap basis?
How u will apply OCS patches? If a user wants to execute a background job immediately but there is no Background work process available. How u will do? How you will do client copy? If SAP * user is not available at all in your system then how u will do client copy?
8 Answers Bosch, IBM, Infosys,
Tell me steps for support pack installation in ecc6?
Diff between local client copy and remote client copy?
How to monitor user accessed transactions (Tcode) day wise?
How do you create an instance?
What type of security problems you will get?
Various client copy methods and how you will do them?
Why is it that Only in SAP-BI / SAP-BW Systems do you have the Profile parameter rdisp/max_wprun_time to be set to a value greater than 600 secs.
The Users are not able to save the data, as a BASIS ADMIN me to not able to save, what is the problem would be..?
i am arun, as of now i am working in a power plant. I did B.E mech and have completed PGDC in thermal power plant engineering from NPTI(NATIONAL POWER TRAINING INSTITUTE). I started my career in software oly , as i dono any software languages i got failed in conformation exam. Pls help me , i want to enter software field. in this powerplant field 6 working days for week and holiday is also not sunday, i am not able 2 tc of my family... pls help me how to enter sf fielf. my frds sujjested me 2 try as functional after 2 years. wats the procedure for that... pls pls help me in this issue I have 1 year exp in power plant, i knew mechanical design software. my id : arun0029@gmail.com
Please Beaware From KPIT Cummins for SAP. They won't have projects but they were hiring .Thay have domestic clients from Pune and Mumbai only.