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 ??
This isn't really a SQL Server question, but typically you'd configure your application pool to recycle periodically, based on a certain memory use and/or certain time intervals.
Yup.. you are right but application's backend is processed using SQL SP's, Triggers..so more the execution time of script greater the CPU size of w3wp.exe process
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.
w3wp.exe issue for asp.net Application
Posted - 09/13/2012 : 09:30:17
