Friday, March 23, 2012

Installing 2000 SQL -- Suggestions?

Hello,
I am in the process of installing our first SQL server in house and after
reading several messages here from this group I have a few questions.
Fist of all, we are having to go with SQL 2000 as both of our applications
we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
is not supported). I already have a WIN2003 AD environment and the new
'rebuilt' server will be a WIN2003/SQL 2000.
How should I configure the hard drives on the new server (I am going to
rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell 2600
Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take a
performance hit with RAID 5? What are the RAID pros/cons from a SQL point?
Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
Thanks for your help!!!Your best performance will happen in Raid 10,this is for storage of the MDF
file.If to expensive use Raid 5.
To maximise I/O in either 5 or 10 use as many physical disks in the array
as supported by controller .As this facilitates read/write to be performed
simultaneously.
--
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
"Mark" <someone@.somewhere@.in.the.world.com> wrote in message
news:OG9#RV#ZGHA.440@.TK2MSFTNGP05.phx.gbl...
> Hello,
> I am in the process of installing our first SQL server in house and after
> reading several messages here from this group I have a few questions.
> Fist of all, we are having to go with SQL 2000 as both of our applications
> we are wanting to move to a SQL enviroment only support SQL 2000 (SQL 2005
> is not supported). I already have a WIN2003 AD environment and the new
> 'rebuilt' server will be a WIN2003/SQL 2000.
> How should I configure the hard drives on the new server (I am going to
> rebuild the box). Should I use RAID 0,1 or 5? Currently it is a Dell
2600
> Dual 2.6 Processor 2GB RAM W2K RAID 5 box. I have heard that we will take
a
> performance hit with RAID 5? What are the RAID pros/cons from a SQL
point?
> Any tips or suggestions for installing SQL 2000 are GREATLY appreciated!
> Thanks for your help!!!
>
>sql

No comments:

Post a Comment