File Placement

Can anyone point me to any Microsoft articals giving reccomendations for file placement for SQL server? We are trying to convince our Hardware guys that we need separate disks for data/log/tempdb files and need some ammo.

Thanks,

Jason

This article may be a good starting point:-

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/storage-top-10.mspx

HTH!

|||

This article reccomends RAID 1, but lots of others say RAID 5?

What's your opinions on what is better?

|||

It really does depend on your data (and what you're willing to spend!!).

For read/write intensive operations (eg tempdb) you want to go with RAID1 as you get the benefit of reading from 2 disks without a heavy penalty of writing. For mainly read intensive you should go for RAID5.

Check out the different RAID levels explained in Books Online.

HTH!