Hardware Suggestions please

We are planning to purchase a new server for our database application.
The server will be running Sql Server 2005 as the RDBMS. The
application is expected to be used by around 10-15 people (power
users). We are expecting some heavy importing(inserting) of data into
the database and also lots of reading. There would be many tables that
would be very huge (more than a million rows).
We have looked at the System requirements for Sql Server 2005 but that
is the lowest common denominator. We have therefore decided on the
following hardware configuration:
Intel Pentium IV
4 GB RAM
500 GB HARDDISK ( may be as two disks)
Any additions/corrections to the above list would be appreciated.
ThanksThere is an article by Kevin Kline called "Bare Metal Tuning" that
gives some great advice on what hardware to use for SQL Server; here's
a link to it, but you need to be a subscriber to SQL Server magazine
(which you should purchase anyway; great resource).
http://www.sqlmag.com/Article/Artic...rver_46492.html
Just off the top of my head, though, you need to really think about
drives and arrangement. A database server needs at a minimum two
physical disk cofigured; one for database files, and one for log files.
I recommend three (add another for tempdb). RAID 10 is the best
setup, but you can use RAID 5.
Others may have more advice, but that's what I could think off in the
short term.
Stu|||You didn't say how many CPU's. Since you're expecting a lot of querying,
going with just one isn't an option. Consider 2 dual-core CPU's. Also,
even though you may have enough storage capacity in your disks, performance
may not be up to the task. The more physical disks you have, the faster
things go - if you go with a RAID10 (striped and mirrored) configuration.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"S Chapman" <s_chapman47@.hotmail.co.uk> wrote in message
news:1146824123.095677.27230@.i39g2000cwa.googlegroups.com...
We are planning to purchase a new server for our database application.
The server will be running Sql Server 2005 as the RDBMS. The
application is expected to be used by around 10-15 people (power
users). We are expecting some heavy importing(inserting) of data into
the database and also lots of reading. There would be many tables that
would be very huge (more than a million rows).
We have looked at the System requirements for Sql Server 2005 but that
is the lowest common denominator. We have therefore decided on the
following hardware configuration:
Intel Pentium IV
4 GB RAM
500 GB HARDDISK ( may be as two disks)
Any additions/corrections to the above list would be appreciated.
Thanks

HA / DR technology for SQL,Oracle,DB2

Does anyone have any reference to some of the terms used by the different
RDBMS vendors for the different HA/DR technology ?
For eg: I think Mirroring on SQL is Data Guard on Oracle and HADR on DB2A quick readup on IBM's HADR at http://www.dbazine.com/db2/db2-disarticles/zikopoulos19 show that it
is basically the same thing as database mirroring. They seem to have three modes (asynchronous,
near-synchronous, and synchronous) compared to SQL Server's two modes. But the technology behind
this are both based on re-playing log records on a standby server.
It seems like Oracle's Data Guard also is similar in implementation to Database Mirroring but with
two options. You either run it same thing as database mirroring. Or, you can have it implemented
pretty much the same way as Transaction Replication (re-generating SQL statements from the log
instead of sending the physical log records), allowing fro different physical database schema on
standby server. http://www.oracle.com/technology/deploy/availability/htdocs/DataGuardOverview.html
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Hassan" <hassan@.hotmail.com> wrote in message news:%23DUxW%239RHHA.4028@.TK2MSFTNGP03.phx.gbl...
> Does anyone have any reference to some of the terms used by the different RDBMS vendors for the
> different HA/DR technology ?
> For eg: I think Mirroring on SQL is Data Guard on Oracle and HADR on DB2
>
>