Interested to Buy Any Domain ? << Click Here >> for more details...
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
What is an index in a database?
Can you explain about buffer cash and log cache in sql server?
What does <> symbol mean?
What is wrong with sql server client libarary dll, ntwdblib.dll?
What are the benefits of filtered indexes?
What should be the fill factor for indexes created on tables? : sql server database administration
What is an index. What are the types?
How can I tell if sql server is 32 or 64 bit?
How to use linked server?
Why de-normalization required?
how many no of arguments can be passed in procedures and functions
Explain the concept of recursive stored procedure.
How to create a simple user defined function in ms sql server?
What are types of subqueries?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
