Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8042 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's the difference between delete table and truncate table commands? : Sql server database administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Which is better statement or preparedstatement?
how to control the amount of free space in your index pages? : Sql server database administration
What is data file in computer?
How to get a list of columns in a view using the "sp_help" stored procedure?
What are the advantages of sql stored procedure?
What is standby servers? Explain types of standby servers.
How can you list all the table constraints in a database?
What do I need to start working with sql studio? : sql server management studio
last function used in MS Access to convert sql what function will use in sql
How does recursive cte works in sql server?
What is wide table?
What types of replication are supported in sql server?
How to use clusters?
