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.
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.