Post reply

Lazy Writer

  • March 6, 2013 at 12:40 am

    #290665

    Hi All

    I want to begin by stating that I have read the corresponding chapters in the SQL 2008 Internals (Kalen Delaney) book and have consulted with other resources as well.

    I just want to confirm my understanding of the lazy writer process.

    The lazy writer process looks after both the data cache as well as the plan cache, using different algorithms for each cache.

    Is this correct?

    Thanks

  • March 6, 2013 at 1:10 am

    #1593807

    What do you mean by 'looks after'?

    btw, first page of search results for 'lazy writer plan cache data cache'

    http://msdn.microsoft.com/en-us/library/ms181055%28v=sql.90%29.aspx

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • March 6, 2013 at 1:34 am

    #1593815

    What do you mean by 'looks after'?

    When the Lazy Writer wakes up, it checks the size of the free buffer list - Does it also check the status of the plan cache?

    Just read the article - Yes, the lazy writer checks the plan cache as well

    I just wasn't sure if the size of the plan cache was also managed by the Lazy Writer or another process

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply