anushahanna
asked on
sys.dm_exec_query_plan Query plan in GUI
When I get the query plan from the above DMV, it is a link to the XML source code. How can I get the graphical plan instead when clicking on it from SSMS?
thanks
thanks
ASKER
yes, I am using SQL 2005, and it just gives the XML code.Do you have to configure it differently in SQL 2005? (than 2008)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Oh, OK.
I searched and got http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
but that seems for 2008 itself. Is there a separate sql2008 client side tools to manage sql2005 installation.
I searched and got http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
but that seems for 2008 itself. Is there a separate sql2008 client side tools to manage sql2005 installation.
ASKER
is the suggestion to put
http://www.microsoft.com/DownLoads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en
on SSMS 2005?
http://www.microsoft.com/DownLoads/details.aspx?familyid=08E52AC2-1D62-45F6-9A4A-4B76A8564A2B&displaylang=en
on SSMS 2005?
I have the SQL2008 managment studio client tools installed, when yo click on the XML it renders the plan for you in icon format? (SQL 2005 just spits out the XML at you)
is this what you want?