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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Database Server Configuration

Author  Topic 

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-01-22 : 04:57:42
We have just bought the new server that has the 200GB of Hard Disk,
and we have implemented RAID5, How should we configure the Database Server.

Carat
Yak Posting Veteran

92 Posts

Posted - 2009-01-22 : 06:06:54
You have only one raid set?

You should not place you transaction logs on the same disk as your data files.

Possible configuration:
C:\ drive: OS and SQL Server on RAID1
D:\ drive: Transaction logs on RAID1 or RAID10
E:\ drive: Data files on RAID5 or RAID10
Go to Top of Page

sagitariusmzi
Posting Yak Master

113 Posts

Posted - 2009-07-10 : 02:17:45
Our Network told us that we only have RAD5 implemented.
Go to Top of Page

tripodal
Constraint Violating Yak Guru

259 Posts

Posted - 2009-07-10 : 15:34:40
If you only have a single volume then you have no options.

The ideal is listed above.

For the average small business user a single raid 5 will provide enough performance.
Go to Top of Page
   

- Advertisement -