Hallo Everyone, I am using an asp.net v2.0 application for which application pool, web site is created. Every day multiple users logged into application for doing transactions doing this in Activity Monitor I came to know that w3wp.exe is taking more than 350 MB of Memory Usage. Due to which application performance is sucked. Generally I restart IIS when the process(w3wp.exe) consumed 550 MB of Memory Usage. This occurs on daily basis no matter whether transactions is going on or not.. So I want to know Is their any permanent solution ??
Did you set up your application pools in IIS to recycle? Other than that I don't have a solution, and as I said earlier, this isn't really a SQL Server issue. You might find a better solution on an IIS forum.