How to import the ST05 trace file into HANA Studio and display as a graph
Some ABAPers might have already noticed this button “Graphical Explain” in tcode ST05 but do not know how to use it properly.
First you can switch on SQL trace via tcode ST05:
And execute the program you want to trace in another SAPGUI window. Once finished, deactivate the trace in ST05.
And press this button to display the trace.
Use this menu to export the execution plan of a given SQL statement into a local file (.plv ):
Then open it via HANA Studio:
Then the execution plan could be displayed in detail as a graph:
You can even paste the SQL statement you observed in ST05 into HANA Studio and execute it there:
Just open SQL Console, paste the source code and press F8 to execute:
There is that saying that "imitation is the nicest form of flattery", so I feel flattered that you liked my blog post (Quick note on Plan Visualization in NetWeaver) from 2013 that much, that you basically re-published it.
🙂
Hi Lars,
Oh my god! I never remembered that I had read your blog in year 2013 🙁 Recently I was assigned with a performance tuning project so I start to learn HANA Studio a little bit, and wrote what I have learned daily into this blog.
Since there is already comment on this blog, it is not possible for me to delete it. I notice that you are community moderator, do you have enough authorization to delete this blog? If so, would you please kindly do me a favor to remove it?
Sorry for inconvenience caused and thanks a lot for your help!
Best regards,
Jerry
Hi Jerry
there's not a problem here! Your blog post should definitively stay online.
It is pretty clear that you didn't mean to copy my blog and sell it as yours.
So, all good mate! How about you share some of your experiences from the performance tuning project you mentioned?
Cheers,
Lars