Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8188 Views
- Microsoft, I also Faced
- E-Mail Answers
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
Does order by actually change the order of the data in the tables or does it just change the output?
What is a coalesce function?
optimization techinques
What types of Joins are possible with Sql Server?
Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
Does index speed up select statements?
What is the use of nvl work?
How to delete all rows with truncate table statement in ms sql server?
How many types of triggers are there?
what types of replication are supported in sql server? : Sql server database administration
What is difference between global temporary tables and local temporary tables?
Your table has a large character field there are queries that use this field in their search clause what should you do?
What is a cube? : sql server analysis services, ssas
What is a performance monitor?
What is sub query and its properties?
