Site Slow

We have hosted our site www.unionpayrollaudit.com on discountasp.net. It is a asp.net 2.0 site using sql server 2005 db. We find the site to be excruciatingly slow at times especially when accessing the sql server database like saving and reading from the database. We have changed the web.config and set the debug mode to false. It does not seem to improve performance much. Can anyone suggest ways to improve performance.

Thank you.

 

Another follow up question :

Can we duplicate the application recycling on our localhost and using our remote productionsql server database?

We have IIS 5.1 on our localhost.

Should we be monitoring the memory used by aspnet_wp.exe process to know when it exceeds the 100 MB limit ?

Currently without even logging in our application on the localhost, the aspnet_wp.exe process uses 81 MB of memory.

Under similar situation of your application recycling, should this memory exceed 181 MB ?

Thank you very much in advance for your kind reply.

 

Thanks for your reply.

We have identified with the help of discountasp.net support that the problem is related to memory leak. We have been informed that the application recycles itself when the memory reaches 100MB limit.

Although we have closed all connections and used object.dispose finally, the memory consumption does not reduce until the session is cleared, even when the objects go out of scope.

On googling, I found that dispose simply informs the gc that the memory is available to be reclaimed if required. It does not immediately reclaim the memory.

My question is - Is there a way to inform the gc of the 100 MB application memory limit so that it can reclaim objects memory that has been disposed off. I am being informed that gc only reclaims memory when required. Unless it knows of the 100 MB limit, the gc may not reclaim the disposed of memory causing my application to be recycled.

Thanks