M
mapexvenus
I have a .NET application that uses SQL server. After some useage I get
the following error:
"Timeout expired. The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use and max pool size was reached"
I looked at the SQL server process info and found process ID's for the
procedures that the application called - they all had the status as
'sleeping'. The timeout expired error happens when the number of
processes reaches the max pool size.
My questions are:
1. why arent these sleeping proecsses processes being reused since all
connections are being closed?
2. Will increasing the max pool size fix this problem?
the following error:
"Timeout expired. The timeout period elapsed prior to obtaining a
connection from the pool. This may have occurred because all pooled
connections were in use and max pool size was reached"
I looked at the SQL server process info and found process ID's for the
procedures that the application called - they all had the status as
'sleeping'. The timeout expired error happens when the number of
processes reaches the max pool size.
My questions are:
1. why arent these sleeping proecsses processes being reused since all
connections are being closed?
2. Will increasing the max pool size fix this problem?