ASP.Net ConnectionStrings have persistent pooling on by default, and SQL Server default has a 600 second Remote query timeout. I assume that for a pooling at works each pooling connection would stay open for a long time.
Does the 600 second default setting affect the use of connection pooling? Such that a random connection timeout error would occur from time to time? or it works with pool seamlessly. Should I change max remote qu开发者_如何学运维ery timeout to 0 (infinite) instead?
Thanks
Of course the timeout affects pooling. If you have long running database queries that stay open for 600 seconds, and new requests are comming in, changes are that the connection pool is running out of connections.
精彩评论