Installing SQL 2000

[mark2020]

I will be installing SQL 2000 on a server with three hard drives. Should I put the Program files and the data files on separate hard drives? Is there other ways to get better performance with three hard drives?

Thanks for your help....

 

[tlbroadbent]

Definitely place the program files, data files and transaction log files on different drives. Do you have RAID arrays installed or just three physical drives?

You should read some articles about configuration and file pacement. The SQL Server Operations Guide is a good resource. See chapter six.

http://www.microsoft.com/technet/prodtechnol/sql/maintain/operate/opsguide/sqlops6.asp

Here are some additional links that should prove helpful.

File Location Tips

http://www.sql-server-performance.com/sql_server_setup.asp#File Location tips

Physical database design

http://msdn.microsoft.com/library/en-us/optimsql/odp_tun_1_8mni.asp

Know Your RAID Levels

http://www.sqlmag.com/Articles/Index.cfm?ArticleID=9697

Optimizing SQL Server Performance Using Files and Filegroups

http://www.sql-server-performance.com/ac_filegroup_performance.asp

Will placing the MDF files and the LDF files on two different physical hard drives help?

http://www.sql-server-performance.com/q&a42.asp

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[mark2020]

I have two Raid 1 arrays (18GB in size) and one Raid 5 array
(100GB in size). I was going to install the operating
system on one Raid 1 array and logs files on the other. Then
install the database on the raid 5 array. This is all
hardware raid. Do you place the databases and log files on
these seperate drives during setup? Also, what is the best place for the program files?

Thanks for your help.

 

[tlbroadbent]

I can't remember if you can specify the LOG location for the system databses during SETUP. I don't belive that you can. You can change them after setup though we don't move system log files on our servers.

You can specify the lcoation of user databaes when creating them.

We have always used the default location for the SQL program files. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.