Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8128 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
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are tables in sql server?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
What happens to a trigger with multiple affected rows?
Why we use trigger in sql server with example?
What can be used instead of trigger?
What is a mutating table error and how can you get around it?
What is a partitioned view?
What does <> symbol mean?
What is the difference between Clustered and Non-Clustered Index?
What is faster join or union?
Can we use having clause without group by?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
