web server setup

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,
FredHere'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
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

web server setup

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,
FredHere'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.comwrote:

Quote:

Originally Posted by

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

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.comwrote in message
news:%23c7EOfY0HHA.1164@.TK2MSFTNGP02.phx.gbl...

Quote:

Originally Posted by

>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