I am setting up a new SQL Server 2014 running on Windows Server 2012 R2. I have two LUNs, one that is RAID 1 which has the OS installed on and the second LUN is RAID 10. I was wondering for best performance how I should setup the data directories? I currently have it set to install these directories in the following location:
Instance root directory: C:\SQL\Microsoft SQL Server\
Shared feature directory: C:\SQL\Microsoft SQL Server\
Shared feature directory (x86): C:\SQL\Microsoft SQL Server (x86)\
Where should I place these?
Data root directory:
User database directory:
User database log directory:
Temp DB directory:
Temp DB log directory:
Log file directory:
Also, should any of the service accounts be changed for any reason?
Thanks for your input.