Matt Crowley (1/24/2014)

---

Web servers use connection pooling, so connections used by one user are recycled by other users. However, if your application does not close connections, they will build...

Let's say all 1000 user really connect at the same time, does any of them use recycled connections from other?

Is establishing connection to SQL Server consumes memory? How much?

How can I determine the 'normal threshold' for my server?

Count of user login?

It's set before I came in here by previous DBA.

Any guidance in deciding the threshold?

I'm quite new in administration.