Alan.B (5/29/2015)

---

I actually did a presentation that covered this very topic at a recent BI user group but don't have the code handy at the moment.

My experience has been that, unless you get a parallel query plan when querying ReportServer.dbo.Catalog.Content the the performance is a disaster.

See this article for forcing a parallel plan. I bet this will help a great deal:

http://sqlblog.com/blogs/adam_machanic/archive/2013/07/11/next-level-parallel-plan-porcing.aspx

All you have to do is create the function that Adam provides in his article then add an addition CROSS APPLY that references the function like so:

CROSS APPLY make_parallel()