topic code inspector, SQL trace in Application Development and Automation Discussions

code inspector, SQL trace

Former Member — Thu, 26 Apr 2007 14:56:24 GMT

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.

Re: code inspector, SQL trace

Former Member — Thu, 26 Apr 2007 14:59:44 GMT

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

Re: code inspector, SQL trace

Former Member — Thu, 26 Apr 2007 15:00:05 GMT

Hi,

Check the following link:

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

Regards,

Bhaskar

Re: code inspector, SQL trace

Former Member — Thu, 26 Apr 2007 15:00:33 GMT

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

Re: code inspector, SQL trace

Former Member — Thu, 26 Apr 2007 15:03:39 GMT

Hi ,

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

Re: code inspector, SQL trace

Former Member — Thu, 26 Apr 2007 15:12:16 GMT

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

Message was edited by:

saroja ponnam