SQL Server 2014, Standard Edition (running under vmware, fwiw). Adding a Dell MD3420 DAS box.
In the old school, you would set up discrete spindle sets for MDF, LDF, TEMPDB, BACKUP.
- MDF: Qty 6: 300GB-15K, RAID 10 // 900GB storage
- LDF: Qty 4: 150GB-15K, RAID 10 // smaller data footprint, spindles to increase IOPS
- TEMPDB: Qty 4: 150GB-15K, RAID 10 // smaller data footprint, spindles to increase IOPS
- BACKUP: Qty 2: 2TB, RAID 1
Use Case: This system has 5 databases, and is OLTP.
Nowadays, I am being told: Just set up Qty 10: 600GB-15K drives, and put MDF, LDF, TEMPDB and BACKUP all on there. The overall higher performance of the larger spindle set more than makes up for the conention writing to LDF and BACKUP concurrently during backups.
- a) Is this new way the right way?
- b) LDF is supposed to be discrete relative to MDF... I feel funny!
- c) I really feel backups should be their own spindle set (for a bunch of reasons)
The winner is ? SQL Tradition? Or the Dell Storage Architect?