Max. number od users in SQL server

[Goran]

How many users can access to SQL server at the same time with web aplication
written in C# 2005? What if my database is 1GB and 1000 people access at 1
second - some simple query. My web hosting acc will be
http://www.webhost4life.com or something simmilar!

 

[Yves. L.]

Hi,
The # of concurrent connection a SQL server handles depends on the
settings of the server.

However if you plan to have a 1000 concurrent users (and 1000 open
connection at a time) you should probably
- implement caching from start in your app.
- check this with your web hosting facility.

YvesL

 

[clintonG]

I've hosted websites at WH4L for several years myself noting I have yet to
deploy any applications that really generate significant demand. However, be
it WH4L or any other hosting provider there is no known way I have ever
heard of to test the performance of a hosting provider's shared hosting
services other than deploy the application and then test and measure
performance repeatedly.

When it becomes apparent your applications are generating significant demand
for resources it is then time to move from shared hosting to your own
server. A 1GB database with 1,000 users is virtually meaningless. SQL Server
can handle just about anything you can throw at it.

<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL http://clintongallagher.metromilwaukee.com/
MAP http://wikimapia.org/#y=43038073&x=-88043838&z=17&l=0&m=h