Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8154 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / adesh saunakiya
Lazy writer function is to write the data pgae from buffer
log to Master data file in cordination with checkpoint
because data page having counter which is refresh it self
from 0 to 1 as the data page is commited its counter is set
to 1 and lazy writer scan the datapage continuosly as it
set to 1 it free the memory in buffer log and save that
page in to master data file physically.
i think thread are the part of a process.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
Does server sql treat char as a variable-length or fixed-length column?
Explain the database you used in your final year project?
What is SQL Azure Data sync?
What are the differences between triggers and stored procedures?
What are four major operators that can be used to combine conditions on a where clause?
How to select some specific rows from a table in ms sql server?
What is the difference between Triggers and Stored Procedure?
What the different types of Replication and why are they used?
What is attribute hierarchy? : sql server analysis services, ssas
What is the difference between functions and stored procedures?
What happens if null values are involved in comparison operations?
What is difference between foreign key and unique key?
Explain partitioned view?
What are different types of raid configurations? : SQL Server Architecture
