How to Find the SQL Traces

When i was working with Performance issues on BEx queries we face so many issues.

While coming  we created BEx reports for dashboard requirement and always users want run the dash board they want immediately.

We made aggregates on cube but again some performance issue came. How do you which object is using frequently then we trace the Dash board BEx queries.

How to find the SQL Trace

1.enter the T- code- STO5

Below screen appear then check the SQL Trace and RFC Trace then select the activate trace with filter – give user name -> USER1.

Select continue

Now see trace activated.

2.Enter the T-code- RSRT

Run the query and it took 8 minutes time

Go to again T-code- ST05

Deactivate the Trace now trace are switched off

Then select the display trace

Then next screen will appear

Filter the object name was Info cube E face table

Double click on the SQL select statement

Below screen will appear

In SELECT statement how many object are using we find easily (for information i am erasing the using all info object) then we made aggregates based on the SQL script.

After making aggregates on cube our dash board report came within 2 minutes.

Hope it will helps.

Thanks,

Phani.

To report this post you need to login first.

25 Comments

You must be Logged on to comment or reply to a post.

  1. Jalina Vincent

    Thanks for sharing the valuable inputs. But i have a doubt on your document. How can we identify on which info object we need to create Aggregates y using the SQL Query. Please suggest.

    Thanks.

    (0) 

Leave a Reply