connection status "suspended"

F

fniles

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top