According to Microsoft best practices you can optimize SQL and take a lot of benefits by using this technique, my only question is how to correctly install the SQL Server to match the drives/paths according to their article:
I got my system partitioned matching the article above:
- C: SYSTEM
- D: TEMP DATA
- E: TEMP LOGS
- F: SERVICES DATA
- G: SERVICES LOGS
- H: CONTENT DATA
- I: CONTENT LOGS
- J: BACKUP DATA
During the setup wizard I'm prompted for the directories (see below) but I can't figure the correct matching for all my drives/paths, I'm not sure at this point if my assumptions are remotely correct, even more, where do "Services Data" and "Services Log" will go? The options below aren't enough to match all my drives, I'm pretty sure I'm missing something and I'm lost here :)
My questions are:
How to match the drivers/directories to meet the aligned partition structure?
Is it possible to configure the Config.ini to automate this scenario?