Home > IT Blogs > SQL Server with Mr. Denny > Easy way to read XML execution plans.
>>VIEW ALL POSTS  

SQL Server with Mr. Denny

« New tip published about table statistics
What is Service Broker? »
Oct 29 2007   8:00AM GMT

Easy way to read XML execution plans.



Posted by: mrdenny
SQL, Execution Plan

Take your XML execution plan and save it to a file with a file extension of sqlplan (such as MyQuery.sqlplan) and double click on it.  It will open in the SQL Server Management Studio and show you the plan in the GUI plan viewer making it much easier to read than the XML version.

AddThis Social Bookmark Button     Comment     RSS Feed     Email a friend

Comment on this Post


You must be logged-in to post a comment. Log-in/Register

Checking the cached execution plans - SQL Server with Mr. Denny  |   May 1 2008   9:03AM GMT

[…] Don’t forget how to view the XML execution plan in the UI. […]