SQL Trace ST05

[Former Member]

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

[Former Member]

Check out this blog

[Former Member]

Hi,

Check this

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

Regards,

Neenu Jose.

[Former Member]

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

Atul Zope

[Former Member]

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

[bpawanchand]

Check this blog

[Former Member]

Many Thanks Everyone.