Hardware requirements

I would like to know what are the suggested hardware
requirements for a Windows 2000 server box with SQL 2000
working in a very much busy environment.This question is so broad I doubt anyone could respond with a good answer.
You would need to perform some baseline testing with hardware to see how
your app performs then purchase appropriately.
-Lars
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...
> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.|||All together now...
"It Depends"
Seriously, you need to define just what 'busy' means. Batch
requests/second, transactions, client connections, database size and
throughput are all part of the mix. Most of the major server vendors have
tools to 'estimate' the size of a host server for SQL. They do a failrly
good job as long as your situation is not too unusual. Without a lot more
information I cannot give even a wild guess as to what you need.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...
> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.|||Ricardo,
It is a loaded question.
It is very hard to give any recommendation or suggestions based ont eh
information you have given.
Please check out the Operations Guide put together by Microsoft at the
following link.
Look at Chapter 6 which deals with Capacity planning. This is a good start.
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/prodtechnol/sql/maintain/operate/opsguide/default.asp
HTH
Satish Balusa
Corillian Corp.
"Ricardo Bruno" <ricardo_bruno@.btsincusa.com> wrote in message
news:424401c3e435$7ef63490$a101280a@.phx.gbl...
> I would like to know what are the suggested hardware
> requirements for a Windows 2000 server box with SQL 2000
> working in a very much busy environment.