inevercheckthis2002 (10/9/2013)

---

Kurt W. Zimmerman (10/9/2013)

---

4) System, Data, Logs & TempDB should be on their separate LUNs.

With sincere apologies the thread hijacking... I'm trying my best to gain insight to the best use of the hardware at hand. It will be in use next week and I'm trying to get it right from the start. I'd follow best practices and recommedations whenever I am able, but sometimes there are limited resources.

I have 16 disks - direct attached storage, one RAID controller. The OS is already on a 2 disk RAID1.

Which is best?

A.) One RAID 10 array across 14 disks, giving me the best I/O from an IOPS perspective. Install data, logs, tempdb - could be separate partitions, if that matters.

B.)One RAID 10 array across 12 disks for Data and Logs (could be separate partitions). One RAID1 (2 disks) for tempdb files, sized as you describe above.

C.) One RAID 10 array across 10 disks for Data. One RAID 1 (2 disks) for logs (simple recovery model). One RAID1 (2 disks) for tempdb files.

It's the same controller and the same disks - wouldn't option A be best?