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