topic Re: SQL Trace ST05 in Application Development and Automation Discussions

SQL Trace ST05

Former Member — Mon, 03 Nov 2008 09:48:50 GMT

Hello,

Can i know how can i use ST05 SQL Trace for checking the performance of my program.

I cheked some of the posts and google also but there is only vague idea.

I need to know what all things needs to be cheked and the diffrent functions in ST05.

Many Thanks,

Neeraj

Re: SQL Trace ST05

Former Member — Mon, 03 Nov 2008 09:50:51 GMT

Check out this blog

Re: SQL Trace ST05

Former Member — Mon, 03 Nov 2008 10:17:21 GMT

Hi,

Check this

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/5a1de990-0201-0010-8d83-a06bdda1d7d5

Regards,

Neenu Jose.

Re: SQL Trace ST05

Former Member — Mon, 03 Nov 2008 10:21:06 GMT

You can use ST04 after executing the program.There you can see all select statements with actual indexes used .

Atul Zope

Re: SQL Trace ST05

Former Member — Mon, 03 Nov 2008 10:22:25 GMT

Hi Neeraj,

Before executing your program click on 'Activate Trace' button in ST05 for SQL Trace checkbox.

Then execute your program.

Goto ST05 and now click on 'Deactivate Trace' button.

Then click 'Display Trace'.

Now you will get the time taken along with no. of records fetches and some more info for each and every SELECT query used in your program.

Whenever you see red color for any SELECT query that means your query has taken more time for execution and you should then try and optimize your query.

Regards,

Saba

Re: SQL Trace ST05

bpawanchand — Mon, 03 Nov 2008 10:24:42 GMT

Check this blog

Re: SQL Trace ST05

Former Member — Mon, 03 Nov 2008 10:38:09 GMT

Many Thanks Everyone.