Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
espino316
Starting Member
3 Posts |
 Posted - 2007-02-06 : 17:16:08
|
| Hi, I wish somebody can tell me how I can to know if a connection pooling is ok based on the number of connections and the average of users who can access to the data base.For example, the production data base has an average of 8.5 connections, and the average of users is 14.I have made corrections already in the application code. I'm using MSSql Server 2000 SP4 and the .NET framework 2.0. The users can acces either a web site and an application based in Windows. |
|
|
rcurrey
Starting Member
30 Posts |
Posted - 2007-02-07 : 09:26:09
|
| In order for connection pooling to work, all users must be connecting through the same library application in Windows or the same ASP .NET application in web. The server app will then use its own identity when connecting to the DB. As soon as the user identity changes, then pooling CANNOT occur, because connection attributes must be identical in order to be pooled. If the Windows app is deployed to the users desktop, then there is no way that the connections could be pooled.Hope this helps.Thanks,Rich |
 |
|
|
|
|
|
Average number of Connections for pooling