Which one would be faster? "OS and Database in the same disk drive", or "OS in one, and database on the other

Question

Which one would be best in terms of the database performance? Did anyone ever try to test out this configuration? Thanks.
-Ade

Answer 1

yes. os on one db on another and page file on another too.

all seperate drives (not partions on 1 drive)



but......



if your using 3 drives, you might as well buy 1 more and run a raid setup (if your motherboard supports it)



your only as strong as your weakest link in a raid setup.

raid copies the structure of the weakest smallest drive onto all 4 HD.

even still, it is much faster than a normal setup

Answer 2

OS on one Data on the other, smaller OS partition as well with the page off of the Hard drive for either,



OS -> just big enough

Data -> however large

Page file -> another physical hard drive on its own.

Answer 3

The latter