We help IT Professionals succeed at work.

ConnectionString Attributes:pooling=true;connection lifetime=120;max pool size=50;"

plord1234
plord1234 asked
on
We recently moved our web site to a new host. They added these attributes to our connection string line in the web.config file: pooling=true;connection lifetime=120;max pool size=50

Please explain what these do and what are the determinants for the values. The

MS SQL Server is running on its own DB server with 4 quad cores and 64 gigs ram.
IIS 7 running on Server with 2 quad cores with 8 Gigs Ram
Comment
Watch Question

CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2015

Commented:
Hi Kaufmed,

I have the definition of the settings.  What I am looking for are the determinants for the values for the settings.  For instance,  why would I use Connection Lifetime=120 why not 240?
Why max pool size = 50?  Why not 100?

What are the consequences when a limit is reached?  Are the number of concurrent web visitors allowed affected by these settings?  What does a web site visitor experience when a limit is exceeded?

What do I examine to determine the optimum values for there settings?  Server capacity?

Author

Commented:
What I was looking for are the determinants for the values for the settings.  For instance,  why would I use Connection Lifetime=120 why not 240?
Why max pool size = 50?  Why not 100?

This ws not provided.