Before long my company will upgrade our existing sql server hardware platform, and i need some advise and thoughts on how to partition disk and set up raid configuration. The new machine will have 8 drives, 4 CPU's (dual-dual core) and 8 GB of ram. We have multiple databases on the server, one of them stand for approx. 70% of the load. The server is dedicated for sql, no IIS or other apps will be running. The normal configuration for such a machine is raid 1 for windows, raid 1 for sql log and raid 0+1 for data, but giving it some thought there is actually quite a lot of different configurations. 1. Put the tempdb on the windows physical drive? Keeping the tempdb seperate is good, and the main database is making heavy use of it. But how much will windows being installed in the same physical drive affect this. 2. Put the log db on it's own physical drives (raid1) Normally this is a good thing, but if we move all the db's logdb on the same drive we will not gain much advantage from the drive head being the same place all the time, so im thinking about only moving the large 1, keeping the rest on the raid 0+1. Any one having input for this? 3. Using 2 x raid 0+1 Only having 8 drives, no other drives can be handled, so this will force me to have Windows + tempdb + log, on one raid 0+1 and data on the other raid 0+1. I hope some of you has some input for me, maybe some with simular hardware. I guess my main question is how important it is to give Windows it's seperate drive.