sql server new users: Typical number of clients supported by one server? -- sql server new users

Typical number of clients supported by one server?

Jesper
12/27/2005 2:57:22 PM

sql server new users:

I have developed a winforms DotNet application which has been tested for
performance and concurrentcy with a few clients on a small MSDE engine. But
I've never done any real scalability testing. The application will go live
with about 50 clients to begin with, but likely to multiply 10 fold soon.

I know that it depends heavily on the client application, but for 'typical
applications': "What is the normal number of clients a standard SQL server
(1 cpu) will support with acceptable performance?"

J.

Re: Typical number of clients supported by one server?

Mike Epprecht (SQL MVP)
12/27/2005 3:42:31 PM

Hi

How long is a piece of string?
It all depends on the application and DB design.

I have worked on application where 5 users killed a server, and other
systems where 250 users still have capacity to spare on a single CPU server.

Testing for performance and concurrency on MSDE is not the best idea. Due to
it's workload governor, you are likely not to have the same usage pattern as
a SQL Server Enterprise Edition with x number of processors.

Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland

IM: mike@epprecht.net

MVP Program: http://www.microsoft.com/mvp

Blog: http://www.msmvps.com/epprecht/

[quoted text, click to view]