During installing SQL 2012 on the Database Engine configuration window
For the Data directories: I am going to give 100GB for all the Drives. My software vendor is going to install management information system on SQL server asked me to create a Drive with 300GB and it will be called as DocumentStorage.
Please let me know the drive I need to assign more space comparative to other Drives.I am not sure the drive that will need more space. Please let me know, which drive that will need more space.
1)Data root directory: D:
2)System database directory:D
3)User database directory: E
4)User database log directory:F
6)TempDB log directory:L
7)Backup directory: B
Secondly: under File stream
On the SQL server we will be installing management information system . 70-90 Clients will be accessing the management information system which is installed on SQL 2012 server.Please let me know if I have to enable this option or not. Just trying to work out to minimise unnecessary services. If I enable File stream do I need to enable all the 3 which is below.
1)Enable File stream for Transact-SQL access
2)Enable File stream for File I/O access
3)Allow remote clients access to file stream Data
Thirdly: Can User database log directory and TempDB log directory on two different folders using the same drive such as L . Will it cause any performance issues.
Please suggest any help much appreciated