This is a utility written by Ivan Arjentinsky that displays the output from SET STATISTICS XML as a tree, rather than the presentation you see in SQL Server Management Studio.
Here is a screen shot:
There isn't that much documentation, but the tool is mainly self-explanatory. (Provided that you have good understanding of execution plans in detail, that is.) One trick is good to know: if you press * while on a node, all nodes under that node are expanded.
You can download just the executable (2.9 MB), or you can download the source code (7.8 MB) if you want to play with it. Note, however, that the tool uses libraries from DevExpress, and if you want to produce your own version of Query Plan Tree, you will need to get a license from DevExperss.
I merely host the tool on my site, and I have not been involved in its development. Please direct any questions about the tool directly to Ivan at ivanarj@abv.bg. Please only mail him about the tool as such. If you want help to interpret execution plans in general, please post your questions to a public forum like microsoft.public.sqlserver.programming.
| First release on my web site |