Lazy Writer

• SQLSACT

  SSC-Insane

  Points: 21838

  More actions

  October 8, 2012 at 7:14 am

  #263656

  Hi All

  Does SQL Server always only use Lazy Write to write dirty pages to disk?

  If SQL Server is under memory pressure, I've read that we should see an increase in Lazy Write/sec. Does that mean that under any circumstance, Lazy Writer is the only process that removes dirty pages from Memory?

  Thanks

• Gail Shaw

  SSC Guru

  Points: 1004504

  More actions

  October 8, 2012 at 8:06 am

  #1546743

  Not being nasty here, but are you using google before posting your questions?

  http://sqlserverpedia.com/wiki/Memory_-_Lazy_Writer_and_Checkpoint (1st hit in google)

  http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/ (3rd hit in google)

  http://blogs.msdn.com/b/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation.aspx (10th hit in google)

  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