Geeky Ninja
Geeky Ninja

Reputation: 6050

After DB restart Application pool required to be recycled to restore DB connection (IIS 7)

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

Answers (1)

Thangamani  Palanisamy
Thangamani Palanisamy

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

Related Questions