I am running a huge SSRS 2008 report (that returns 2 million records) and it gets rendered sometimes and sometimes it gives me an error,
"The report execution <some string> has expired or cannot be found. (rsExecutionNotFound)”.
When I see SQL Server log after this issue comes I see following message there;
"A significant part of sql server memory has been paged out. This may result in performance degradation. Duration: 300 seconds. Working set(KB): 97672, memory utilization 42%"
IMPORTANT point to note here is when I am running reports with 1 million records or smaller than that, then I am able to execute them successfully without any issue.
I am using SSRS 2008 64 bit, Win Server 2003 64 bit. RAM is 8GB.
Please help me to know what are these issue, are these two issues related and how to fix it?
View Complete Post