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
Explain atomicity?
How many replicas are maintained for each SQL Azure database?
What are sql servers used for?
How do I find the sql server version?
What are audit control procedures?
What the class forname () does?
Give me a SQL Query to find out the second largest company?
How to send a ssrs report from ssis?
What is stored procedures?
What are points to remember while using the fillfactor argument?
What type of locking occurs during the snapshot generation? : sql server replication
What do you understand by SQL*Net?
whats new about truncate in sql server 2008?
Define master database?
What are transactions in sql?