SSRS reports not running when there is more than one request

Question

I am running my ssrs report very well when single instance is running.As it is integrated in asp.net 4.0 live application.Now i am facing problem when multiple user simultaneously started to run the report.The reports get crashed and showing the following error in Bold.

"there is insufficient system memory in resources pool to run this quey."--- this i gets when running 3 instance of the report from Bids(Bussiness intelligence development studio ) cunnected to live database.

While running the live application through browser i get this error:--

An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database. (rsReportServerDatabaseError)
        For more information about this error navigate to the report server on the local server machine, or enable remote errors

 

Please help as i feel helpless on this issue..

I did googling but not find any proper solution.

One more thing My report server having 2GB Ram.

Answer 1

Hi Wikram Goswami SE,

Thanks for the question. Based on my research, this issue may be caused by the low Available Memory and resources for Report Server Applications.

1. Available Memory.

As we know, when the report dataset query being executed, it will spend much memory source. If the available memory size is too low, after few times, the Report Server will redistribute these resources to other reports, so please increase the size of the Available Memory.

Configuring Available Memory for Report Server Applications.

2. System resources.

Although the Available Memory is big enough, if the system resources is limited, after few times, system will recycle the resource from the report then redistributing the resource to other applications. Please try to free sources by disabling the unimportant startup items, then rebooting the machine.

Please try to test previous suggestion in your project. If the issue still exists, please feel free let me know.

Thanks,
Sharp Wang

---

Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Answer 2

Hi Sharp wang,

Many thanks for your reply.

I am agree with your answer and think it should surely help BUT...

I have already go through the process Configuring Available Memory for Report Server Applications. and set the value like this

 

  <MemorySafetyMargin>80</MemorySafetyMargin>
      <MemoryThreshold>90</MemoryThreshold>
      <WorkingSetMaximum>1700000</WorkingSetMaximum>
 

But this not help me any more,i don't know why ..?

I done nothing for optimize the system resource as i think there is no other application is running on our server.

Could i have to increase my RAM?

Please suggest me over this.

Thanks & Regards

Vikram Goswami

Answer 3

Thanks for the reply, Vikram Goswami. Since you had increase the Memory size for SSRS, but it has no effect. Based on the first post, the report server just has 2GB Ram, so I guess the most likely reason is less System resources. In this condition, please try to release the sources by disabling the unimportant startup items. If the issue still exists, please consider increase the physical RAM.

Best Regards,
Sharp Wang

---

Please remember to mark the replies as answers if they help you and unmark them if they provide no help.