web server setup

[Fred]

I have a server that will be running as a web server and a database server?
To get the best performance is it better to install the database and web
server on seperate physical hard drives? or it doesn't matter?
I have a total of 8 harddrives, what RAID setup should i choose?

Thanks,
Fred

 

[Bill Nicholson]

Here's a definition of some RAID levels: http://www.webopedia.com/TERM/R/RAID.html
You can implement level 0 for improved performance but you will need a
controller that supports what you want to do. Try to avoid RAID at the
O/S level - get some hardware that will handle it for you.


On Jul 28, 10:25 pm, "Fred" <fredbb...@yahoo.com> wrote:
> I have a server that will be running as a web server and a database server?
> To get the best performance is it better to install the database and web
> server on seperate physical hard drives? or it doesn't matter?
> I have a total of 8 harddrives, what RAID setup should i choose?
>
> Thanks,
> Fred

 

[Anthony]

Fred,
Yes it is.
There isn't one setup you should choose. You need to juggle the following:
- mirrored pair gives more performance than RAID5
- SQL Log File can be better on its own drive separate from the SQL data,
allowing both to be written at the same time
- OS page file ideally on separate drive, but its a toss up between this and
the SQL log file.
So a typical setup would be either mirrored pair for OS plus RAID5 for data
or mirrored pair for OS, mirrored pair for SQL logs and RAID5 for data.
Other factors to consider: more memory to save writing to disk enterprise
editions to use more memory.
Anthony
http://www.airdesk.co.uk



"Fred" <fredbb123@yahoo.com> wrote in message
news:%23c7EOfY0HHA.1164@TK2MSFTNGP02.phx.gbl...
>I have a server that will be running as a web server and a database server?
> To get the best performance is it better to install the database and web
> server on seperate physical hard drives? or it doesn't matter?
> I have a total of 8 harddrives, what RAID setup should i choose?
>
> Thanks,
> Fred