Hello All,
I am setting up a brand new SQL 2012 Server. I have configured this server with three different RAID arrays to maximize disk performance. A mirror for the OS, a mirror for the log files and a RAID 10 array for the databases. My question is in regards to the Data Directories tab of the Database Engine configuration page of the install. I am asked to provide locations for the following.
Data root directory:
User database directory:
User database log directory:
Temp DB directory:
Temp DB log directory:
Backup directory:
Should those be split up onto the different arrays just as I am our databases? IE the db's on the RAID 10, the log files on the log mirror and the backup dir on the OS mirror? And where would the Data root directory fall in that? Here is what I am proposing. Is this the best practice?
Data root directory: My RAID 10 array
User database directory: My RAID 10 array
User database log directory: My Mirror for logs
Temp DB directory:My RAID 10 array
Temp DB log directory: My Mirror for logs
Backup directory: My Mirror for the OS
I appreciate the feed back. I hope to complete the installation this morning.
Best regards,
Daniel
I am setting up a brand new SQL 2012 Server. I have configured this server with three different RAID arrays to maximize disk performance. A mirror for the OS, a mirror for the log files and a RAID 10 array for the databases. My question is in regards to the Data Directories tab of the Database Engine configuration page of the install. I am asked to provide locations for the following.
Data root directory:
User database directory:
User database log directory:
Temp DB directory:
Temp DB log directory:
Backup directory:
Should those be split up onto the different arrays just as I am our databases? IE the db's on the RAID 10, the log files on the log mirror and the backup dir on the OS mirror? And where would the Data root directory fall in that? Here is what I am proposing. Is this the best practice?
Data root directory: My RAID 10 array
User database directory: My RAID 10 array
User database log directory: My Mirror for logs
Temp DB directory:My RAID 10 array
Temp DB log directory: My Mirror for logs
Backup directory: My Mirror for the OS
I appreciate the feed back. I hope to complete the installation this morning.
Best regards,
Daniel