Simple Recovery and Log location?  
Author Message
HsvDan





PostPosted: Tue Jan 10 11:49:28 CST 2006 Top

SQL Server >> Simple Recovery and Log location?

If I have my recovery mode set to simple will I get any performance
boost by having my transaction log on a different physical disk than my
data files?

It seems like there should be the exact same benefit as full recovery
mode but I would like to here what you guys say.

SQL Server28  
 
 
Tibor





PostPosted: Tue Jan 10 11:49:28 CST 2006 Top

SQL Server >> Simple Recovery and Log location? > It seems like there should be the exact same benefit as full recovery
> mode

Correct. The only exception would be the minimally logged operations, if you have such. Since they
produce fewer log records, you will see less of a difference for these by separating the log.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/




> If I have my recovery mode set to simple will I get any performance
> boost by having my transaction log on a different physical disk than my
> data files?
>
> It seems like there should be the exact same benefit as full recovery
> mode but I would like to here what you guys say.
>

 
 
Ryan





PostPosted: Tue Jan 10 11:50:02 CST 2006 Top

SQL Server >> Simple Recovery and Log location? In "Simple Recovery" the .ldf file is still used, the difference being once
a transaction completes the space in the log file used by that transaction
is reclaimed. It's needed to ensure transactions that don't complete
properly can be rolled back.

Moving it to another disk should reduce IO to the data volume and aid query
performance



--
HTH. Ryan


> If I have my recovery mode set to simple will I get any performance
> boost by having my transaction log on a different physical disk than my
> data files?
>
> It seems like there should be the exact same benefit as full recovery
> mode but I would like to here what you guys say.
>


 
 
Dave





PostPosted: Tue Jan 10 12:44:51 CST 2006 Top

SQL Server >> Simple Recovery and Log location? Thanks guys! That is what Iwas looking for.