• 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.
0
JRockFL
Asked:
JRockFL
1 Solution
 
TempDBACommented:
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.
0
 
VIVEKANANDHAN_PERIASAMYCommented:
Yes, it will increase the performance if you store the data and log file in different drives.
0
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