Convert Query Execution Plan XML to Graphical View

Convert Your SQL Server Query Execution Plan from XML to Graphical View

1) We can get queries execution plan from below DMV – 


2) Column query_plan is having execution plan in XML form.

3) When we click hyperlink in query_plan column, in SQL 2005,2008 & 2008 R2 it will open as XML

However, in SQL 2012 it converted to graphical view…..

4) To convert XML to graphical view, save XML file/output with extension .sqlplan & open it again within SSMS.

5) We can now see a graphical view.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: