How to find expensive SQL statement, if found, what should
be done?

Answer Posted / naveen

Use TCode ST03N.Go to transaction profile and see 0DB Time
and 0 Responce time.
Check the Average sequential Read time by STAT and STAD.
Select the object in Red and

Is This Answer Correct ?    0 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is sox and sod in sap ?

1301


What is the role of “ application server” ?

640


what is garbage collector. is there any way to set the time to gc?

3618


How to perform a sap-export and import tables in sap from os level?

782


What are the activities you done in EP?

1304






What is the use of account id in logon tab?

1659


Have u applied patches what is the transaction code?

638


what can we do if shadow instance is down and getting up in prepare phase of upgrade

2130


What are the Pre- requisite for system copy?

1370


Explain what is the importance of table t000?

701


What is business kpis ?

573


What are the key activities that you perform as part of sap basis support?

589


What are common background jobs that will run in your system?

2123


How to apply job on OS Level?

1308


How many times bdls transaction executes for 2 clients

1409