June 9, 2008 at 8:36 am
Hi,
we are facing a performance issue where a set of reports are scaling up to 650 users without the export to xl option activated but when the export is done, the system throws an out of memory exception.
is there some settings that can be set to correct this error. please advise.
Prabhav
June 10, 2008 at 12:00 pm
so x64 or x32? sp and cu level ?
we sort of had a similar thing with pdfs - went to x64 and the problem went away ( but the new servers are silly powerful compared to the old x32 ones )
If you're x32 then x64 is the answer - I guess you may be having bottom memory problems?
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
June 12, 2008 at 3:34 pm
Hi,
Sometimes tweaking your IIS settings can help.
Within the Application Pool folder, locate your Report Server and right click > properties. Here you can configure settings for the number of worker processes for the application pool, the amount of memory which they may consume, as well as control the frequency of garbage collection.
I have often found that a worker process can hold onto memory even when it is not actually carrying out any work. I reduce the recycle times for worker process threads thereby making additional memory available to newly spawned threads/the server in general.
Hope this helps.
Cheers,
John
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply