Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Maximum Connections

 
   Database Help (Home) -> Connect RSS
Next:  Planning for SQL Server 2005: 64-bit, OS, process..  
Author Message
Steve A

External


Since: Feb 17, 2005
Posts: 1



(Msg. 1) Posted: Thu Feb 17, 2005 12:40 pm
Post subject: Maximum Connections
Archived from groups: microsoft>public>sqlserver>connect (more info?)

Hi

We have an ASP.NET web application running on Windows 2003 connecting to a
SQL Server 2000 database on the same machine, currently with 450 users,
approx 10-20 concurrent users. We use Windows Authentication for logging on
to the web application which is configured so that each user connects to the
database using their own NT user account. We have ASP.NET connection
pooling enabled and are aware that for each user connecting to the database
a new connection pool is created. Min pool size is set to 0, max pool size
is set to 100. We are finding it difficult to work out the maximum number
of connections (both total and concurrent) the system will allow in its
current state. Anyone any ideas?

We are also trying to come up with a quick short term solution to deal with
an increase in users in the near future as we are sure that the system is
nearing its current limit. Would changing the system to use one NT group
login into sql server be a preferred configuration? Would scaling up
hardware be the first step? Any other short term ideas would be greatly
recieved.

Regards
Steve A.

 >> Stay informed about: Maximum Connections 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Cannot generate SSPI context - Hi All, I am experiencing problems with a remote user (w2k pro,sql 7) attempting to connect and replicate with a Sql Server 7 on NT server. They are receiving 'Cannot generate SSPI context' messages when trying to use a vb app over a vpn. This problem..

connection string does not work for a different server - Hi all, I currently have an ASP .Net project running locally, and accessing a local SQL server 2000 database. The project runs fine since it is able to open the connection to the database, and perform operations on it locally using a connection dtata..

IIS 6 and Windows Authentication to SQL Server 2000 - I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server...

SSL Security error -ConnectionOpen(SECDoClientHandshake) - Please help. On my default instance of SQL Server 2000, which could be accessed OK with both Windows and SQL server authentication, I now get the error in the subject line above. The message in the error window - in SQL server enterprise manager- suggest...

Connecting client to SQL Server via Cisco VPN - We are having one client PC running Win XP. SQL Server has been set to Windows Authentication, TCP/IP 1433, Windows 2003 (!). Via Cisco VPN we are making a connection. IAS has been configurated, so the local user profile doesn't matter. The server..
   Database Help (Home) -> Connect All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]