Slow ASP.NET Crystal Reports - Restart the web site?
Posted on 2010-03-26
My client has an ASP.NET 1.1 website which uses Crystal Reports. It runs on a Windows 2000 server (one box for both web and sql [msde]) with IIS 5.0.
In the last day or so, some of the crystal reports take too long and the browser can't display the web page (IE message). Script timeout is set to about 30 minutes while execution timeout is set to several hours. It seems like page times out after about 20 minutes.
These are existing reports and I don't think the size of them has grown. I suspect the website needs to be "rebooted" but I don't want to restart the entire box since there may be other web sites running on it. Short of restarting the server and / or IIS, what can I do to clear out any accumulated junk for our website?