What is difference between process and thread?
Explain lazy writer funcationality.
Answer Posted / sachin nandanwar
Its a rubbish answer what adesh has posted.
Lazy writer and checkpoints are NOT related to each other.
Lazywriter will come into picture only when there is memory
pressure by changing the size of buffer pool or when it
periodically finds dirty pages which have not been used for
a while and flushes those pages to the hard disk.It drops
the pages from the buffer cache to free the cache.
Checkpoint on other hand also checks for dirty pages and but
will not drop pages from the cache instead will mark the
page clean in the cache after flushing it to disk.The
primary purpose of checkpoint is to keep the recovery time
as low as possible and not memory management.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What are the steps you should follow to start sql server in single-user mode?
Can you explain what is the use of custom fields in report?
How to convert a table data in XML format in sql server?
How to list all user names in a database?
What is relationship? What number of sorts of relationship are there?
How to filter records of table in SQL SERVER?
What is Federation and Federation Member?
What is a unique key constraint?
What are different backups available in sql server?
What is the most common trace flags used with sql server?
What command would you use to add a column to a table in sql server?
What is system stored procedures?
How many triggers you can have on a table?
What is the difference between a function and a stored procedure?
Define inner join in sql server joins?