You are implementing an ASP.NET Web application that connects to a Microsoft SQL Server database using the following connection string:

server=.;database=NorthWind; User Id=application1; Password= h85hEveR; Min Pool Size=10;Max Pool Size=100

You must determine how many connection pools the application will create to ensure that connection resource usage is optimized.

How many connection pools will the application create?

Each connection pool is associated with a distinct connection string. When a new connection is opened, if the connection string is not an exact match to an existing pool, a new pool is created. Connections are pooled per process, per application domain, per connection string, and, when using integrated security, per Windows identity. In this case a single user ID and password is used to connect to the database. All connections are within a single connection pool.