You are implementing an ASP.NET Web application that connects to a Microsoft SQL Server database using the following connection string:
server=.;database=NorthWind;Integrated Security=SSPI;Min Pool Size=10;Max Pool Size=100
Users authenticate to the Web application using their Microsoft Windows credentials. 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, the connections are configured to use integrated security. Each user has a discrete Windows identity resulting in the creation of a connection that is pooled separately. There is one connection per connection pool.