I am using SQL 2005.
Starting from today, when I do sp_who, every few minutes I see a new
connection to the database and the status is "suspended".
This new connection comes from the same VB.NET program that inserts data to
the database.
After a while, the program will get the 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."

What does the status "suspended" mean, and will it use up all the connection
from the pool ?
How can I fix this ?

Thank you

Looks like COMMIT TRANSACTION fixed the problem.


"fniles" <(E-Mail Removed)> wrote in message
news:unH%(E-Mail Removed)...
>I am using SQL 2005.
> Starting from today, when I do sp_who, every few minutes I see a new
> connection to the database and the status is "suspended".
> This new connection comes from the same VB.NET program that inserts data
> to the database.
> After a while, the program will get the 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."
>
> What does the status "suspended" mean, and will it use up all the
> connection from the pool ?
> How can I fix this ?
>
> Thank you
>

"fniles" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Looks like COMMIT TRANSACTION fixed the problem.
>
Or Rollback Transaction

http://msdn.microsoft.com/en-us/library/ms181299.aspx