• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 486
  • Last Modified:

Transaction log and data file

I have a dedicated server with Sql Server 2008 and raid 1.
Currently, the transaction log and data file are on the same drive.

Should I move one of them to the other drive?
What this improve performance?
It is an e-commerce web application that receives around 2000 unique visitors per day.
1 Solution
It is always good to locate both log and data file in separate drives as in IO operation can happen at both the drives simultaneously.
Yes, it will increase the performance if you store the data and log file in different drives.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now