Do log caching options and recovery have any implications on SQL Server 11.0.x?
Log caching should cause no difference in behavior with regard to recovery. The implications for user log cache are that there will be fewer spinlocks, which improves concurrency in multiprocessing, and you may avoid logging begin and commit transaction records when no changes have occurred (for example, with the sequence: begin, select, commit).
Related Questions
- Are there different options for SQL Server auditing like writing to database, OS file, system log, etc. and if so what do we recommend?
- Why do results of recovery contain less data than the original SQL Server database, backup and log?
- Can Recovery for SQL Server repair my SQL Server database, backup and log?
