INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Where to Store User DB and Temp DB

Where to Store User DB and Temp DB

(OP)
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

RE: Where to Store User DB and Temp DB

I'd venture say your proposed configuration is correct. You have the OS on a separate disk, the logs and the data files on their own separate volumes too. Unless your tempdb is gonna be a very busy one, it's gonna be just fine on the RAID 10. If your backups are going to be on you OS volume, just make sure you have enough space. Monitor your backup files and ensure that they are deleted every so often, dictated by your needs of course.

MCP SQL Server 2000, MCTS SQL Server 2005, MCTS SQL Server 2008 (DBD, DBA)

RE: Where to Store User DB and Temp DB

(OP)
Thanks for the reply! I spoke with a consultant at the end of the day yesterday and he also said those were the correct choices. Glad I seem to have a consensus of SQL experts agreeing!

Daniel

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close