November 28, 2012 at 6:46 am
Hello,
I am stuck with one scenario.This is my query.
SELECT TOP (2) qp.query_plan
FROM sys.dm_exec_query_stats AS qs
CROSS APPLY sys.dm_exec_query_plan(qs.plan_handle) AS qp;
It is giving XML execution plan with link.If I click
on any one of link,it will open an graphical execution plan in SSMS.
Now i have used this query in SSRS Report and
displaying report. In report it is showing only plain XML
text, it is not showing any link.
So, i have to open a graphical plan when user click on
XML execution plan link in SSRS?
Is there is any way to do this?
November 28, 2012 at 6:55 am
XML is handled by the application if you want it to be anything more than just text with funny punctuation.
SSRS isn't built to present XML as a graphical plan. Has nothing to do with the XML itself, it's the application you're using to consume it. You'll either need to build or find an application that can display user-friendly execution plans in a web browser, if you want to look at them outside of SSMS.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
November 28, 2012 at 8:33 am
No way I know of to do this.
There is a third party tool, Plan Explorer from SQL Sentry, that will let you open execution plans. But I'm pretty sure you won't be able to integrate it into SSRS.
"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 Plans
SQL Server Query Performance Tuning
November 29, 2012 at 5:43 am
Thank you for replies.!!! 🙂
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply