05-28-2007 7:52 AM
What is the difference between Runtime Analyasis * SQL Tracer, and what is special use of individual Tools
05-28-2007 7:55 AM
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
05-28-2007 9:17 AM
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.
05-28-2007 10:57 AM
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
05-28-2007 11:18 AM
05-29-2007 11:07 AM
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
05-30-2007 6:10 AM
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