Post reply

Basic question - Where SSRS stores the data retirived from remote data source?

  • September 29, 2010 at 12:18 pm

    #229867

    Hi,

    I am kind of unsure that if I am connecting to a remote datasource to get the data for my report (SSRS 2008), once the data is retrieved where it will be stored?

    Is it in buffer pool of sql server present in local machine(where report server also resides)?

    or is it stored in report server catalogs?

    Regards,

    Sachin

  • September 29, 2010 at 12:27 pm

    #1229266

    It's placed in memory. Depending on the size of the resultset it can also be dumped to disk.

    [edit]

    This is an assumption based on what I have observed. Run a report with a large data set an you can see the ssrs process memory usage go way up. At a certain point there will be temp files created in the ssrs temp directory when memory usage gets to high. I've read that it gets put into the report server tempdb but mine is tiny and I know I've had result sets that were double the size of the report tempdb.

    Good question. I'd kind of like to know for sure.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply