Flowing Fount of Yak Knowledge
Posted - 11/02/2006 : 17:11:56
| I have some profiler traces that I run which collect the usual stuff as well as the Show Plan All event class.
When run from the profiler GUI, I can see the StmtText in the bottom portion of the screen. However, when I load this trace into a SQL table to do some more in-depth analysis I can no longer see the StmtText.
What is the trick in converting the binarydata to something that can be read by a human? Anyone have any scripts, or links that shed some light on this? I googled around and found these KB articles that are on the right track, but are not specific to my question of how to display the show plan data.
btw, if I just collect the execution plan I have no problem viewing the text. This issue is only with the "Show Plan All" information. Thanks.
Edited by - eyechart on 11/02/2006 17:38:40