topic Re: Difference between Runtime Anlaysis & SQL Tracer in Application Development and Automation Discussions

Difference between Runtime Anlaysis & SQL Tracer

Former Member — Mon, 28 May 2007 06:52:54 GMT

What is the difference between Runtime Analyasis * SQL Tracer, and what is special use of individual Tools

Re: Difference between Runtime Anlaysis & SQL Tracer

Former Member — Mon, 28 May 2007 06:55:15 GMT

1. Run Time Analyser

http://help.sap.com/saphelp_47x200/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

2. SQL trace

http://help.sap.com/saphelp_47x200/helpdata/en/d1/801f7c454211d189710000e8322d00/content.htm

Regards,

Santosh

Re: Difference between Runtime Anlaysis & SQL Tracer

Former Member — Mon, 28 May 2007 08:17:20 GMT

Hi sidiveshu,

For program perform analysis purpose , we will use this process.

First,

you should go with SE30,

There u find your program process times,

if u r program process is more in ABAP process, then u should continue with SE30,

when your program takes more process in Database , then you go with SQL Trace Analysis,

here you have chance to analyse query wise,

if u useful, some rewards

Regards,

bhaskar.

Re: Difference between Runtime Anlaysis & SQL Tracer

Former Member — Mon, 28 May 2007 09:57:27 GMT

Hi Jogu,

SE30 -

> Used To Find Program process Times. it show some Graph , and MicroSecond In Red color.

ST05-------> Used to Find out more Process in Database, its also useful to find out table.

Give The Point. if Usefull,

Thanks ,

Majed Khan

Re: Difference between Runtime Anlaysis & SQL Tracer

Former Member — Mon, 28 May 2007 10:18:24 GMT

Please go through the links

http://help.sap.com/saphelp_nw04/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

http://www.sap-basis-abap.com/sapta002.htm

Re: Difference between Runtime Anlaysis & SQL Tracer

Former Member — Tue, 29 May 2007 10:07:01 GMT

hi,

run time analysis

Tcode : SE30

in run time analysis u can find evaluation of time and percentage of the effect on database.

do one small exercise

1) go to se30

2) execute from there,

3) then click on analyze button.

4) there u can see execution time in micro seconds.

5) for better performence all way all the three bar there in se30 should be in green colour.

SQL Trace

1) TCODE is st05

2) this is trace to analyze the select statements weather the selects are effective or ther is any other way of writing the select statements.

both are used to check performence od the report.

Thanks,

Madhukar

Re: Difference between Runtime Anlaysis & SQL Tracer

Former Member — Wed, 30 May 2007 05:10:17 GMT

Runtime analysis and SQL trace ar both used for an Performance tunning of an ABAP programs (any) ...

because when you run huge reports it will take some time ..... and it will cause other customer users those whoare making transcation to the same tables .... so for that the proragms are tunned ....by using some process which was standardly given by sap ...

ST05 -> SQL Trace .

SE30 -> RUNTIME ANALYSIS

in runtime analysis you see the time taken by the system and the data utilised , database tables accesses and its time...etc .

in sql trace you can swithc off/on the trace of any running programs so that you can se the specific of any ABAP porgrams ... which has taken time for which table ... which SQL query....etc ...

so basicaly in the SQL trace it was checking of the sequesnce of the table query for SELECT,

UPDATE

MODIFY

INSERT

DELETE

REFRESH ....etc ....

Girish