<div>
Yes, it will increase the performance if you store the data and log file in different drives.
</div>


Yes, it will increase the performance if you store the data and log file in different drives.

<div>
<div class="content wysiwyg-content">
I have a dedicated server with Sql Server 2008 and raid 1.<br />
Currently, the transaction log and data file are on the same drive.<br />
<br />
Should I move one of them to the other drive?<br />
What this improve performance?<br />
It is an e-commerce web application that receives around 2000 unique visitors per day.
</div>
</div>


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.

Transaction log and data file

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.