ado.net connection pooling question
Posted on 2011-03-21
I'm trying to understand connection pooling as it relates to a multi-threaded application.
If I have 5 threads continuously running and they all create a sql connection, shouldn't I have 5 distinct connections to the db? Using the sql trace I don't see but 2.
If I up my threads to 10 the connection count doesn't change. Inside the thread, the connection is opened and closed as it is used.
I understand the connection pooling just returns it back to the pool but I would still think I would have more than 2 connections at any given time. The threads run very quickly but upping the thread count doesn't seem to improve performance.