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