Mark Shvarts 1
SSCertifiable
Points: 5702
More actions
October 29, 2007 at 11:40 am
#376546
XML excution plan that's returned from sys.dm_exec_query_plan function is too huge and hard to read.
Is it possible to retrieve it or convert it in a graphical mode ?
Thanks.
Grant Fritchey
SSC Guru
Points: 398890
October 29, 2007 at 12:31 pm
#746366
Save it to disk with the extension .sqlplan. You can then reopen it as a graphical execution plan.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
October 30, 2007 at 12:12 pm
#746808
Thanks Grant, this is smart trick.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply