SQLTeam.com | Weblogs | Forums

Connection Pool Lifetime setting

Is anyone using the "Connection Lifetime" setting in a connection string?

https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ole-db-odbc-and-oracle-connection-pooling

We are considering enabling this. We have multiple parallel database servers and we are going to use this to make it easier to move servers in and out of use.

I was curious if anyone has any experience.