Sql SErver 2000 and concurrent users

[st]

I have sql7 and another instance of sql2000 running on this sql server.
Here is the server's configuration:
Quad CPU's 700Mhz. Xeon 1MB Cache
4GB RAM
W2K
4 CPU licenses for SQL2K

I realize that # of concurrent user you can have with acceptable performance
depends on your application and database design etc..
I will like to know if there is an estimated optimal ratio of SQL server resources to concurrent users.

[Karl]

Typically, you should allocate approximately 500 KB of RAM per concurrent user. This accounts for the connection and some shadow processes.

Therefore, with 4 GB of RAM you can have 8000 concurrent users. Of course, you have to allow for the size of the database and how much that is going to take up in terms of resources, so you will have far less than 8000 concurrent users available.

I hope this is what you were looking for.

Karl


------------
st at 3/21/01 10:54:44 AM


I have sql7 and another instance of sql2000 running on this sql server.
Here is the server's configuration:
Quad CPU's 700Mhz. Xeon 1MB Cache
4GB RAM
W2K
4 CPU licenses for SQL2K

I realize that # of concurrent user you can have with acceptable performance
depends on your application and database design etc..
I will like to know if there is an estimated optimal ratio of SQL server resources to concurrent users.