Reputation: 6050
I have got one situation, if I restart the Database connected to my web application (in .Net), I have to recycle the application pool to restore the DB connection for my application.
Without recycling of application pool, i couldn't able to connect to my application. Does anyone let me know is there a way to not to do the manual recycle the application pool to restore DB connection?
Or, there are any way to restore DB connection without recycling Application pool?
Upvotes: 0
Views: 3057
Reputation: 5300
The app pool is the webservices deployed on your iis instance. They can either be backend services behind your website or front end webservices. Either way if you are restarting SQL server instance it means that these webservices are either losing their connection to the database or it's become non-responsive for that DB session.
By refreshing the pool you are fundamentally restarting the application and re-establishing the DB connection(s).
Taken from
https://serverfault.com/questions/222385/what-does-recycling-the-app-pool-actually-do-exactly
Upvotes: 1