Home Forums Reporting Services SSRS 2012 Out of memory error RE: Out of memory error

  • November 26, 2014 at 4:46 am

    #1761042

    aicha.techn (11/26/2014)

    I've also noticed that other reports even if they take time running but they use just 3GB of RAM. So I think that the report which takes all the RAM might contain an infinite loop or something like that. How can I verify this hypothesis?

    Thank you

    Code analysis I guess. Don't have much experience querying cubes so can't aid much along those lines.

    I've never encountered an out of memory issue in RS on the server before. Is the SQL database engine running on the same server, and if so, is Max mem on that set to a realistic value?

    Are the figures for Max & Min Working Set above the actual ones you've used? They're only 768 and 512MB respectively.

    The RS service also needs to be restarted before the values will take effect.

    Thanks