[Last Call] Learn how to a build a cloud-first strategyRegister Now


Transaction log and data file

Posted on 2012-08-22
Medium Priority
Last Modified: 2012-08-22
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.
Question by:JRockFL
LVL 25

Accepted Solution

TempDBA earned 2000 total points
ID: 38322433
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.

Expert Comment

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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question