Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Improve Performance using SQL trace

Go to solution
Former Member

‎2008 Jun 20 10:02 AM

0 Likes
403

Hi,

I am using a report painter for which i have to improve the performance using SQL trace.

can anyone help me in how to use SQL trace?

1 ACCEPTED SOLUTION
Read only

Go to solution
valter_oliveira
Active Contributor

‎2008 Jun 20 10:10 AM

0 Likes
379

Hello.

Use tcode ST05 to achieve that:

Turn on the trace, run your report, turn off the trace and run trace analisys.

For more info, go to this help:

http://help.sap.com/saphelp_nw70/helpdata/EN/5a/ace273ca0211d194b500a0c94260a5/frameset.htm

Regards,

Valter Oliveira.

2 REPLIES 2
Read only

Go to solution
valter_oliveira
Active Contributor

‎2008 Jun 20 10:10 AM

0 Likes
380

Hello.

Use tcode ST05 to achieve that:

Turn on the trace, run your report, turn off the trace and run trace analisys.

For more info, go to this help:

http://help.sap.com/saphelp_nw70/helpdata/EN/5a/ace273ca0211d194b500a0c94260a5/frameset.htm

Regards,

Valter Oliveira.

Read only

Go to solution
Former Member

‎2008 Jun 20 5:15 PM

0 Likes
379

follow this guideline, if you really what to improve something

SQL trace:

/people/siegfried.boes/blog/2007/09/05/the-sql-trace-st05-150-quick-and-easy