10-18-2007 6:30 AM
Is there any other transaction except SE30 to check the performance of the report,
Regards
Rajaram
10-18-2007 6:32 AM
10-18-2007 6:32 AM
Hi,
you can use ST05 to do the SQL Trace and check whether the SQLs are using proper index or not..If the SQL is not using proper index..Then the performance of the program might not be good..
Thanks
Naren
10-18-2007 6:32 AM
10-18-2007 6:33 AM
Hi,
You can use Transaction ST05 - Performance Trace
In this, you need to first activate the Trace,
then execute your program and go back to deactivate
then analyze the execution details..
Regards,
Samson Rodrigues.
10-18-2007 6:35 AM
hi,
try with this Tocdes
ST05 -
SQL QUERY ANALYSIS [ PERFORMANCE ANALYSIS ]
ST30 -
GLOBAL PERFORMANCE ANALYSIS
if helpful reward some points.
with regards,
Suresh Aluri.
10-18-2007 7:02 AM
10-18-2007 7:15 AM
Hi,
Like i said above,
You need to first ACTIVATE the trace,
then open a new window and execute your program,
After the execution is completed, go back to the Trace window and
click on DEACTIVATE Trace,
Then finally click on DISPLAY trace and Click OK on the PopUp
You can see the Database fetches and their duration that the program took.
P.S. always DEACTIVATE the Trace after you have finished else the Server may still
continue to Trace for no Reason.
Regards,
Samson Rodrigues.