Home Forums Article Discussions Article Discussions by Author Discuss content posted by Paul Randal Clearing the Transaction Log RE: Clearing the Transaction Log

  • June 2, 2010 at 3:05 pm

    #1175593

    Oleg Netchaev (6/2/2010)

    C. VLFs are overwritten with zeroes? No, in Windows nothing is overwritten with zeroes as there is no need to do that.

    Hey Oleg,

    Log files are initialised with zeroes (there's some complexity around that - see Paul's blog and Jonathan Kehayias' entries:

    http://sqlblog.com/blogs/jonathan_kehayias/archive/2010/05/13/does-the-tempdb-log-file-get-zero-initialized-at-startup.aspx

    Windows uses zero-initialised memory pages too (see Demand Zero Pages).

    Paul

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi