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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-10-09 : 10:13:11
|
| jet writes "we are intending to get a new machine that will host SQL SERVER 7 as well as IIS. this machine will serve atleast 200 concurrent users. pls. tell me the required machine specs (i.e. ram, no. of cpu's, etc) that we should consider before we even proceed with the purchase. is there a 'formula' to correctly determine the suitable pc specs in order to smoothly serve a certain no. of users? thanks very much." |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2002-10-09 : 10:54:24
|
First let say that 200 concurrents connections is a heavy load of visits!! If you want only one machine, I would go for at least 4 processors and depending of the insert/select ratio maybe one machine will not be enough. By the way, at my job we made some test and we saved one machine taking MYSQL online instead of MSSQL but this is another debate  |
 |
|
|
|
|
|
sql server 7 host pc specs