Could you please share your guidance on the following SQL exercise?
Objective: Using SQL Server 2014 Enterprise Edition, I plan to implement a 17TB db on a single Windows Server 2012, over 5 drives 4TB each.
Challenge: As far as I can tell, in order to spread the db over several drives, I have the following two options;
1)Use the Windows OS Spanned Volume functionality, essentially the OS layer reports the 5 - 4TB drives as a single drive 20TB drive to applications such as SQL server
2)Use the SQL's 2014 FILEGROUP functionality, thus, assigning tables or indexes to different FILEGROUPs and then placing the files for those FILEGROUPs on different physical drives
Which of the above options would you recommend? are there other Windows & MS SQL options to reach the objective?