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 is 1nf 2nf and 3nf?
Explain candidate key, alternate key, and composite key?
What protocol does sql server use?
Do you know the capabilities of cursors?
What are the grouping functions?
What happens to a trigger with multiple affected rows?
What do you understand by triggers?
How to disable stored procedure sql server?
What is transaction server isolation?
What are the advantages of using a stored procedure?
What is a ddl statement?
What is sqlservr.exe - process - sql server (sqlex?press)?
How to create a large table with random data for index testing in ms sql server?
What is data compression?
Does partitioning improve performance sql server?