Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8176 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
How do you delete duplicate rows in sql server?
What is nolock hint in sql server 2008
What is sql collation?
1 01 101 01010
What language is sql server written in?
Working with TLogs
Hi all, can any one please tell me the difference between sql server 2008 and orace 9i
Can primary key be null?
How to delete exactly duplicate records from a table?
What is history table in sql server?
What is a raid and what are different types of raid configurations?
Explain system rowset functions?
Ways to improve the performance of a SQL Azure Database?
What is difference between line feed ( ) and carriage return ( )?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
