Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8046 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
What is service broker? : sql server database administration
Explain trigger classes i.e. Instead of and after trigger?
What do you understand by recursive stored procedure?
What is difference between index and primary key?
How to use "begin ... End" statement structures in ms sql server?
Ms sql server index?
What is normalization of database?
Explain what is cte (common table expression)?
What is the order by used for?
Explain identity in sql server?
Why would you call update statistics?
What happens if the update subquery returns no rows in ms sql server?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
what are user defined datatypes and when you should go for them? : Sql server database administration
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
