On a server with 5 hard drives, I presume a 2-drive raid-1 and a 3-drive
raid-5 (each 146gb) would be the appropriate config.
The user databases only take up 10-20GB.
This is for a very busy web site, so maintasks are reading and fulltext
search.
What would you recommend locating on the raid-1 as well as the OS?
Thanks SOC.If it's really a busy system, then you should seperate the TLog and Data
files of the database. You should locate the TLog on a RAID1 and locate the
data files on a RAD10 if possible, if not then RAID5.
Locate your OS and SQL Server binaries on a RAID1 so in this case, you'll
need 2 more disks :)
--
Ekrem Önsoy
"SOC" <zxc1@.hotmail.com> wrote in message
news:uXNvyrADIHA.972@.TK2MSFTNGP05.phx.gbl...
> On a server with 5 hard drives, I presume a 2-drive raid-1 and a 3-drive
> raid-5 (each 146gb) would be the appropriate config.
> The user databases only take up 10-20GB.
> This is for a very busy web site, so maintasks are reading and fulltext
> search.
> What would you recommend locating on the raid-1 as well as the OS?
> Thanks SOC.
>
>|||Consider placing the transaction logs and tempdb there. HEAVY writes, which
suffer on RAID5. Your mostly-read application 'should' be ok on the RAID5.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"SOC" <zxc1@.hotmail.com> wrote in message
news:uXNvyrADIHA.972@.TK2MSFTNGP05.phx.gbl...
> On a server with 5 hard drives, I presume a 2-drive raid-1 and a 3-drive
> raid-5 (each 146gb) would be the appropriate config.
> The user databases only take up 10-20GB.
> This is for a very busy web site, so maintasks are reading and fulltext
> search.
> What would you recommend locating on the raid-1 as well as the OS?
> Thanks SOC.
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment