Skip to Content
Author's profile photo Kodanda Pani KV

How to find SQL Traces

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.

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Good one !

      I would like to give it a try.

      Thanks for sharing !

      LS

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comments 🙂 🙂

      Author's profile photo Former Member
      Former Member

      Simple and clear steps 🙂

      Thanks Phani.

      Reg,

      Phani.

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comments 🙂

      Thanks,

      KV.

      Author's profile photo Pavan Kumar K R
      Pavan Kumar K R

      Nice Insight.. 😎

      -- KRPK

      Author's profile photo Former Member
      Former Member

      Nicely explained in a very precise manner ,good 🙂

      Best regards,

      Praveen Srivastava.

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks Praveen and Pavan your comments and appreciate to me 🙂 🙂 🙂

      Thanks,

      phani.

      Author's profile photo Former Member
      Former Member

      Good Pani.

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comment.

      Author's profile photo Former Member
      Former Member

      Nice doc Pani.

      Thanks for sharing.. 🙂

      Regards,

      Poorna

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Hi poorna,

      Thanks for your comments.

      Phani.

      Author's profile photo Former Member
      Former Member

      Nice Document.

      Regards,

      Sushant

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for you comments 🙂 🙂

      Phani.

      Author's profile photo Former Member
      Former Member

      Hi Kodandapani,

      Really Informative. Keep Posting 🙂

      Thanks,

      Purushotham.

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks purushotham your comments. 🙂

      Thanks,

      Phani.

      Author's profile photo Former Member
      Former Member

      Nice document and thanks for sharing.

      Kiran.

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Good one pani 🙂 .

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comment Ganesh.

      Author's profile photo Yogesh Narwani
      Yogesh Narwani

      Nice Info.. Thanks for Sharing..!

      Regards

      YN

      Author's profile photo Chandra Janardhansudhir Kunar
      Chandra Janardhansudhir Kunar

      Hi Phani,

      Thanks for the document.

      In ST12  there are lot more options. Wish you include it as well, may be useful for many of us.

      Thanks &  Regards,

      Sudhir

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your compliments.

      i know RSTT but i didn't see the the ST12 and which T-code explain.

      Thanks,

      Phani.

      Author's profile photo Antony Jerald J
      Antony Jerald J

      Hi,

      Really informative document. Thanks for sharing 🙂

      Author's profile photo Phani KV
      Phani KV
      Blog Post Author

      Thanks for your comments.

      Phani.

      Author's profile photo Jalina Vincent
      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.

      Author's profile photo Former Member
      Former Member

      Nice doc..Keep it up..!