Re: SQL Server Hardware requirements
From: David Gugick (davidg-nospam_at_imceda.com)
Date: 02/16/05
- Next message: tina miller via SQLMonster.com: "Re: sql question"
- Previous message: David Gugick: "Re: sql question"
- In reply to: James: "SQL Server Hardware requirements"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 16 Feb 2005 14:42:18 -0500
James wrote:
> I know this is somewhat off topic, but what type of hardware would you
> recommend for the following.
>
> Server with 100 users (usually 50-80) online at same time, accessing
> a sql 2000 database that is 14 gigs.
>
> What would you recommend for cpu type/speed, ram amount, and raid
> configuration
>
> thanks
Depends entirely on what the database is doing. Simple transactions
wouldn't require a lot of power. OTOH, if they are doing a lot of
reporting then disk, CPU, and memory are more important. Also depends
on your budget. What are these 50-80- users doing?
If the transactions are short, you'd probably be fine with a simple
dual-cpu config, 2GB RAM. You database is small, so you likely won't
require a lot of hardware. While I'm not a RAID 5 fan, a simple mirrored
RAID set for the OS, tempdb, and log files, and a 4-5 disk RAID 5 array
for data would probably be fine. However, I would say that it's better
to use a 4 disk RAID 1+0 config for the data, given your small data
size.
Maybe even a simple mirror for data would work, depending on the server
load. It all depends... on a lot of factors, including price.
If you can provide further details, I'm sure the ng members will provide
additional recommendations.
-- David Gugick Imceda Software www.imceda.com
- Next message: tina miller via SQLMonster.com: "Re: sql question"
- Previous message: David Gugick: "Re: sql question"
- In reply to: James: "SQL Server Hardware requirements"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
