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 |
|
guaro
Starting Member
5 Posts |
 Posted - 2006-11-10 : 10:02:46
|
| Hi gurus I have the following server and I need help setting up the best raid for my sql.My server: 2x cpu \8GB ram\I have 6 HD 146GB each 15K rpm\ 1 sa-6402 two channel array controller.my goal: best performance and best array using what I have, this is for a sql2000 database. Thanks for all the help guys |
|
|
dewacorp.alliances
452 Posts |
Posted - 2006-11-11 : 23:47:00
|
quote:
My server: 2x cpu \8GB ram\I have 6 HD 146GB each 15K rpm\ 1 sa-6402 two channel array controller.
I assume you are not using SAN technology. Due to limitation on your server, what I recommend is: Raid 1 for for System (C:), Raid 1 for Data (D:) and Raid 1 for TLog (E:).For D and E ensure to put into a separate physical disc. |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-11-12 : 01:52:30
|
| Your options are very limited with only 2 channels on the array controller.Maybe 2 disk RAID1 for OS and transaction log files, and 4 disk RAID10 for the database data files.You didn't supply any specifics about the application, so it is hard to give more than a guess.This is something you should have decided before you purchased hardware.CODO ERGO SUM |
|
|
|
guaro
Starting Member
5 Posts |
Posted - 2006-11-12 : 09:18:29
|
| Thanks guys for the reply.- 1) The application is an in house application that most of the time is a writing process more than reading process.2) The server was already here when I came on board, just trying to utilize what I have. thanksthanks for all your help |
|
|
|
|
|
|
Sql setup