topic Re: Sql trace in Application Development and Automation Discussions

Sql trace

Former Member — Fri, 11 Feb 2005 21:35:40 GMT

Hi All,

I am new to this ABAP field..

I know how to do SQL trace ....But what I am not getting is " HOW CAN WE TELL FROM THE OUTPUT OF SQL TRACE, THAT THIS IS THE CAUSE OF SLOW PERFORMANCE OF A REPORT" Based on what are we determining the performance?

Can Anybody help me here pls?............

Kelly

Re: Sql trace

ssimsekler — Fri, 11 Feb 2005 21:48:34 GMT

Hi Kelly

Try "Runtime Analysis Tool" instead. The transaction code is "SE30". There you can analyse database calls, etc... and see what takes how much time during runtime.

*--Serdar

Re: Sql trace

athavanraja — Sat, 12 Feb 2005 03:06:15 GMT

From the SQL trace you can find,

1. are there recurrsive database calls

2. What index a particular selecte statement is using

3. What is the cost per database read

4. Which database read is taking more time, etc

Regards

Raja

Re: Sql trace

christian_wohlfahrt — Sat, 12 Feb 2005 09:08:26 GMT

Hi Kelly,

if you really have no idea, why a report is slow, then you have to start with SE30 (runtime analysis).

There are three bargraphs: ABAP / database / system.

System should be more or less nothing.

If ABAP is bigger than database: have a look at slow abap-statements (normally operations with internal tables: read, delete, loop where,...); classic reason: to much reads without binary search / sorted table / hashed table use.

If database is bigger than ABAP: have a look at your SQL statements. If you can see already forgotten key fields, fine - otherwise SQL trace will bring help in analyzing.

A SQL trace itself says nothing about overall performance (which is done by runtime analysis), only about database part. But 'normally' programmers have their ABAP-part in control and struggle only with slow selects: that's the reason, why often SQL trace is used immediately.

I hope, this brings a little bit light in your question,

regards,

Christian

Re: Sql trace

Former Member — Mon, 14 Feb 2005 15:39:28 GMT

Hi Everybody,

Thanks for helping me out....

Christian, Your reply really answered my all questions... Thanks...

Kelly