Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Lazy Writer Expand / Collapse
Author
Message
Posted Wednesday, March 6, 2013 12:40 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:37 AM
Points: 1,379, Visits: 2,688
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
Post #1427212
Posted Wednesday, March 6, 2013 1:10 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 39,976, Visits: 36,337
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 2008, MVP
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

Post #1427222
Posted Wednesday, March 6, 2013 1:34 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, September 22, 2014 4:37 AM
Points: 1,379, Visits: 2,688
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
Post #1427231
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse