So I'm trying to troubleshoot a particular SSRS RDL Report that literally takes forever to run (mostly because it has a mile of SQL to run).
My question is: Is there any way to retrieve the execution messages from a Dataset? (i.e. 15 row(s) affected).
My reasoning is that executing the SQL directly with static parameters tends to be much faster than using the RDL.
Note I'm not using the pagination thing that tries to keep all of the rows on one page, nor is the ending dataset all that large (a little less than 1500 rows), it's just the processing that's odd.
Ideally I just want the messages stream returned as a string to display as a tooltip.
Clarification: I'm primarily doing this to compare script portion performance between sections of code. Essentially, someone merged a bunch of stored procs into one, and it is my job now to figure out why it's suddenly taking 20x longer to run, but only when called on SSRS.
I was thinking of using a Global Temp table to store "log" entries, but I have no idea how to control which datasets get executed in which order for rendering, so I haven't attempted that; though it seems almost like the most likely to work based on info below/