code inspector, SQL trace

[Former Member]

Hi all,

Can anyone help me to analyse the output of sql trace and code inspector that we do for a program.

Thanks & regards,

Saroja.

[Former Member]

Hi,

refer the link

http://help.sap.com/saphelp_nw04/helpdata/en/17/358df9c9fee2469105731e10756921/content.htm

/people/randolf.eilenberger/blog/2007/03/12/code-inspector146s-performance-checks-i

Hope this will solve your problem.

Award points if it helps.

-Gaurang

[Former Member]

Hi,

Check the following link:

http://www.sapbrain.com/TOOLS/SQLTRACE/SQL_TRACE.html

Regards,

Bhaskar

[Former Member]

SQL trace(ST05) provides the developer with the ability to analyse database select statements. Simply execute ST05 to turn on SQL trace, then execute the statement/program you want to analyse. Now turn off SQL trace using ST05

and click on list trace to view the details.

If you notice performance issue, you can perform an SQL trace :

1 - ST05

2 - Activate trace

3 - Run your prog.

4 - Deactivate trace & display it !

You'll see accessed tables, with runtime, etc...

You can also perform traces on other items such as authorisation objects.

Authorisation trace analysis 1. Open two sessions

2. Execute transaction ST01 in one of the sessions

3. Select the authorisation checkbox, note the other traces

you can perform (SQL, RFC, Table Buffer etc)

4. Click the 'Trace On' button

5. Within your other session execte the transaction/report

you want to trace or get the user in question to do it

6. Return to the session where you turned the trace on and

click on 'Trace Off' otherwise it will continue to record

all athorisation checks

7. Click on the 'Analysis' button

8. Enter appropriate data into selection screen such as

Username, type of trace records (i.e. Authorization check)

9. Click on the Execute button.

10. Report displaying trace results will now be displayed

http://www.sapdevelopment.co.uk/perform/perform_sqltrace.htm

Code inspector is a static check on your code. This check highlights statements that MAY cause long run times or inconsistant results.

This is new as of 6.10, it can be installed on 4.6C or 4.6D systems.

Code inspector includes the checks from the earlier 'Extended program check', (also transaction SLIN). The transation code for 'Code inspector' is SCII.

Regards,

Amey

Message was edited by:

Amey Potale

[Former Member]

Hi ,

Give me your mail id I will forward a material regarding it..

[Former Member]

my email id is vashatkara@yahoo.com if possible send it to my mail.

Message was edited by:

saroja ponnam