Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2009-11-13 : 09:21:38
|
| I've recently developed a report that displays a large amount of data. This report will be run over night and emailed to several people. The original report was in Crystal and has been re-developed. When I test the report on report manager, I'm doing so with a parameter. This will select a smaller section of the data to test. However, on testing the parameter within SQL Server I get 23000 rows back. When I try to run the report from Report Manager, I get the error message:Server Application Unavailable The web application you are attempting to access on this web server is currently unavailable. Please hit the "Refresh" button in your web browser to retry your request. Administrator Note: An error message detailing the cause of this specific request failure can be found in the application event log of the web server. Please review this log entry to discover what caused this error to occur. When I check the logs I can see I get this:aspnet_wp.exe (PID: 4316) was recycled because memory consumption exceeded the 613 MB (60 percent of available RAM). I've checked the report server and surly enough there only appears to be 1 gig of RAM. I'm not 100% sure this is what's causing the report to fail however!I'd liike to ask for some advice on what steps I could take to resolve this. I've heard somethig about stopping asp recycling so that it doesn't time out but am not sure if this would work or how to do it.I'd like to make the step of buying more RAM the last step.Many thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-11-13 : 09:29:14
|
IMHO 1 gig of RAM is nothing...I would prefer the last step 
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
cidr
Posting Yak Master
207 Posts |
Posted - 2009-11-13 : 10:33:35
|
| I know, it's ridiculus. Thanks for the opinion webfred. Even if I do get round this, without more RAM, it would be sloppy |
|
|
|
|
|
|
Getting Error (Server Application Unavailable) whe