Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkrinsky
Starting Member
3 Posts |
 Posted - 2007-11-01 : 10:37:09
|
| I have a SQL 2000 server that is installed on a Dual Xeon server running win2k. The server has two raid 5 hard drives, a C drive and an E drive.The C drive is currently where the operating system files are stored as well as the SQL program files. As things stand there are SQL DB and transaction logs strewn between these two drives with no particular logic.My question is, with two drives as it stands how should I move things around to gain the best performance? For example, should I keep all my data on the E drives and all my transaction logs on the C drives with the OS and the program files?There are about 10 Databases in use. One database run's the configuration for proprietary predictive dialing software. The other databases are calling information for each campaign we run within the dialing software.I have enough space on both drives to accommodate the data, its performance I would like to see a difference in. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2007-11-01 : 11:50:51
|
| I have enough space on both drives to accommodate the data,The server has two raid 5 hard drivesWhy raid 5?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
wkrinsky
Starting Member
3 Posts |
Posted - 2007-11-01 : 12:07:22
|
quote:
Originally posted by nr
I have enough space on both drives to accommodate the data,The server has two raid 5 hard drivesWhy raid 5?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
Thats how the server was configured this way when I received it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-01 : 22:26:33
|
| If you are looking for best practice, the server should have more disk arrays to hold os, db data files, db log files, tempdb and backup separately. |
|
|
|
wkrinsky
Starting Member
3 Posts |
Posted - 2007-11-05 : 11:18:22
|
quote:
Originally posted by rmiao
If you are looking for best practice, the server should have more disk arrays to hold os, db data files, db log files, tempdb and backup separately.
I understand that; however, I have the hardware in place now with the logical drives set as is. The server is used 6 days a week full time and partially on the 7th day so I cannot rebuild it.With the current setup, what is my best bet? |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-11-05 : 13:43:32
|
quote:
Originally posted by wkrinsky
I have a SQL 2000 server that is installed on a Dual Xeon server running win2k. The server has two raid 5 hard drives, a C drive and an E drive.The C drive is currently where the operating system files are stored as well as the SQL program files. As things stand there are SQL DB and transaction logs strewn between these two drives with no particular logic.My question is, with two drives as it stands how should I move things around to gain the best performance? For example, should I keep all my data on the E drives and all my transaction logs on the C drives with the OS and the program files?There are about 10 Databases in use. One database run's the configuration for proprietary predictive dialing software. The other databases are calling information for each campaign we run within the dialing software.I have enough space on both drives to accommodate the data, its performance I would like to see a difference in.
If you can change the raid configuration I would recommend going with RAID 10 for the E: drive, put all the databases and logs on that drive.
Future guru in the making. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-11-05 : 13:49:57
|
| No database files should be on the C drive. We can't really help you with performance due to your hardware config and not being able to change it.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
|
|
Best practice for db design on 2 drives