web server setup

  • Thread starter Thread starter Fred
  • Start date Start date
F

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
 
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
 
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
 
Back
Top