What is difference between process and thread?
Explain lazy writer funcationality.
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 to make a column nullable?
What is difference between primary key and foreign key?
What Is Rdbms?
How do I know if localdb is running?
What is 'Join' and explain its various types.
Difference between Sql server reporting services and Crystal reports?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
What is the maximum size of a dimension? : sql server analysis services, ssas
What is default port number for sql server 2000?
What are cursors and when they are useful?
What is difference between global temporary tables and local temporary tables?
What are the advantages of sql azure?
How to add the custom code in Report?
How many types of the database links?
What is standby servers? Explain types of standby servers.