Retrieve XML of large plan from plan cache
For 157MB in Tools -&gt; Options -&gt; Query Results -&gt; SQL Server -&gt; Results to Grid screen you will need to set Maximum Characters Retrieved -&gt; XML data to unlimited as below.