We are using Report Server to generate quite large report sets (up to 6000 pages, or 10Mb excel files).
Because of this, we adopted the Report Server solution instead of a client side report architecture, facilitating processing of these large data sets.
Our server has 32Gb of RAM and is used exclusively as a report server.
The stored procedures to retrieve the data in question executes in around 25 seconds.
Telerik Report Server will, however, still often fail with an out of memory exception.
What concerns me is that the amount of data we use is nowhere near 32Gb in size.
Currently, there is also only one or two users on the server at any point in time.
The out of memory exception is also inconsistent: Sometimes these reports will run fine, other times the memory exception crops up, resutling in an extremely inconsistent server experience.
What happens when 1000 users in the production environment tries to run the reports and the server actually has to behave like a server?
Did we make a mistake adopting Telerik Report Server instead of Microsoft Report Server?
Are we missing something?