Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Difference between Runtime Anlaysis & SQL Tracer

Former Member
0 Kudos

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

6 REPLIES 6

Former Member
0 Kudos

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.

Former Member
0 Kudos

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

Former Member
0 Kudos

hi,

<b>run time analysis</b>

<b>Tcode</b> : 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.

<b>SQL Trace </b>

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

Former Member
0 Kudos

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