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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 load limit of single sql server?

Author  Topic 

qutesanju
Posting Yak Master

193 Posts

Posted - 2010-10-12 : 03:53:21
i have an application with 14500 users with heavy db trafic per user
there is load balancing in web server for web requests
the max pool size of one of the web server is set to 300 and other sevrer is 100
rightnow on the production the no os users are concurrently logging in of 4-5 k in a minute
and users getting the null connection
both web servers are pointed to single sql server
how much pool size should i increase on the web server so that the load can be handled by sql server?
   

- Advertisement -