James_DBA (11/9/2009)
While the FULL recovery model will log more details to the log, the SIMPLE recovery model will log minimal details....
Only if those inserts could be minimally logged. Otherwise the logging will be the same
but, where the performance is loss is when these transactions are committed. The FULL recovery model will continue to add transactions to the list in the log; while the SIMPLE recovery model will continously clear (TRUNCATE) the log upon each checkpoint.
Why do you say there'll be a performance loss on commit if the log is getting cleared (of inactive portions only) on a checkpoint?
Got some tests that show the performance degradation?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability