May 22, 2014 at 10:32 am
This may sound like a strange question - but when I render a report in SSRS that is actually pulling data from another server on a different network (different company and location), where does that data live when the report is rendered? The reason I ask is I am pulling data from an Oracle system from a different companys DW, and I am able to render after some time (about 500K records), but when I try to export to .csv it takes a while, but finally errors out with a not very useful message, but was wondering if the data is in a temp table that I could pull. I am guessing that is too easy, but wondered where the data is stored while the report is rendered.
Thanks,
Brian
May 22, 2014 at 11:13 am
Some of the report data will be cached locally on the report server. Large reports may error out due to memory issues. Depending on the number and size of reports, you may see the report data flushed from cache more quickly so it would have to pull across the wire. There is also a time limit on the cache that could possibly be invalidating old report data.
Here is a bit more on report caching.
http://msdn.microsoft.com/en-us/library/ms155927.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply