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 - 2006-03-02 : 07:56:04
|
| Saurabh writes "I need some help in calculating hardware requirements for our DB Server hosting MS SQL Server 2000.This DB server will be accessed by a COM server and 200 client machines simultaneously to insert,update and read the data. The client machines will have an application developed in .NET 2.0some of the tables in the database may have 1 million records.Please give me some info related to my query.Thanks and Reagards,Saurabh SumanInnodata Isogen" |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2006-03-03 : 09:19:05
|
| That's a loaded, text-book question. Is this for real life or for an exam? The reason why I say it's a loaded question is simple. Your .NET app or even your stored procs/ddl could be designed very poorly and you wouldn't see the results that you would generally expect out of a given set of hardware for a server. If I were you, I'd hire a consultant to come in and evaluate your application and make recommendations on your hardware for your new SQL Server.Have fun,Daniel, MCP, A+SQL Server DBAwww.dallasteam.com |
 |
|
|
|
|
|
SQL Server 2000