Tuesday, June 03, 2008

FAQ : What is the difference between Lazywriter and Checkpoint in SQL Server

Lazywriter
The lazywriter thread sleeps for a specific interval of time. When it is restarted, it examines the size of the free buffer list. If the free buffer list is below a certain point, dependent on the size of the cache, the lazywriter thread scans the buffer cache to reclaim unused pages. It then writes dirty pages that have a reference count of 0. On the Windows 2000, Windows Server 2003, and Windows XP operating systems, most of the work populating the free buffer list and writing dirty pages is performed by the individual threads. The lazywriter thread typically has little to do.

Checkpoint
The checkpoint process also scans the buffer cache periodically and writes any dirty data pages to disk. The difference is that the checkpoint process does not put the buffer page back on the free list. The purpose of the checkpoint process is to minimize the number of dirty pages in memory to reduce the length of a recovery if the server fails. Its purpose is not to populate the free buffer list. Checkpoints typically find few dirty pages to write to disk, because most dirty pages are written to disk by the worker threads or the lazywriter thread in the period between two checkpoints

Refer
http://msdn.microsoft.com/en-us/library/aa175260(SQL.80).aspx
BOL
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/4b0f27cd-f2ac-4761-8135-adc584bd8200.htm

2 Comments:

Anonymous Anonymous said...

Located near Statesville North Carolina in
the town of Hiddenite, which is named after the gem found at
the mine. If you have lower defence you can survive as well, but it won't be as easy. This is still faster than dropping your entire inventory.

Here is my site; mining

11:22 AM  
Anonymous Anonymous said...

Djelloul: The Mafia has been portrayed in many ways
in books and movies, and I don't have a quarrel with these portrayals, because the Mafia is a work of many facets. He spoke slightingly but without bitterness of everything he had written, and I knew his new book must be very good for him to speak, without bitterness, of the faults of the past books. Newspaper production is known to be the most lucrative and respected industry in the modern age. Generally Tuyetkegel Blognic could be consisted of any types such as social, economic, political, art, cultural, terrorism, suicides, religious, health, technology, science, business, marketing, and disaster news. This also means that you trust those who have already used the products and know how they are used.

My web page ... click here

9:45 AM  

Post a Comment

Subscribe to Post Comments [Atom]

<< Home