Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8266 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 are the methods used to protect against sql injection attack?
What is the use of set nocount on/off statement?
What is checkpoint process in the sql server?
What are functions in the sql server?
If user is owning any SQL Objects, can we drop that user
what are constraints? Explain different types of constraints? : Sql server database administration
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What are extended events in sql server?
Define master database?
What are data files?
What function does a database engine serve in the sql server?
What are types of subqueries?
Can primary key be a foreign key?
What is the web service used for reporting services?
Can we create clustered index on composite key?
