SQL Installation on new server - Should I move my log file

  • I am reading here and there that for optimal perfomance I should keep my SQL Log files on a different HD...

    the server i ordered has an OS disk in addition to where is tore my DB itself, should I put the logs on the OS Drive?

  • If it's not expected to get big then keeping your data and log files on the same disk should be fine. Just keep them off your OS drive. From your config (1 machine, 2 drives) I'm assuming a small database.

    If your db is expected to get bigger (gb+) and you want the utmost performance, you'd want to have multiple drives (not just partitions) raided on a good quality san (can get very expensive).

    Ideally, what you want is to minimize IO contention on your database. I'd keep tempdb, the data and logs all on separate drives and I wouldn't even use the OS drive for any of the databases including master, msdb...

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply