Dird (4/20/2013)
GilaMonster (4/20/2013)
Lazy writer does not do writes to the transaction log.
Oh lol I meant log writer -_ I should have just said LGWR like i wanted to >_<
It's not the log writer process that logs the changes either. It's the process running the update that generates the log records (and they're just the changed columns) and writes it to the log.
Log writer and lazy writer are only concerned with writing already made log records/changes to disk.
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