Answer Posted / samba shiva reddy . m
The job of the lazy writer is to find dirty pages in the buffer pool and write them out to disk and drop those pages from cache. It does this to keep a certain amount of free pages available within the buffer pool for data that may be requested by other queries. The pages that it writes out are ‘older’ pages, ones that haven’t been used for a while.
If there’s lots of available buffers, the lazy writer will be doing relatively little work and the number of pages written to disk will be quite low. If the lazy writer’s consistently writing lots of data, it may indicate that there’s a memory bottleneck.
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
How do I view a procedure in sql server?
what is a self join? : Sql server database administration
How to get a list of columns in a view using the "sp_columns" stored procedure?
What are the different types of lock modes in sql server 2000?
List out different types of normalizations in sql server and explain each of them?
Explain what is log shipping?
what is denormalization? : Sql server database administration
Explain log shipping and mention its advantages.
How to set a database state to offline in ms sql server?
What are data driven subscriptions?
What are the restraints imposed on the table design by a merge replication?
What is default constraint in ms sql server?
What is the openxml statement in sql server?
What do you mean by an execution plan? How would you view it?
what purpose does the model database serve? : Sql server database administration
