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 – 

SYS.DM_EXEC_QUERY_PLAN

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.

 

Thanks

Advertisements

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s

%d bloggers like this: