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
Tell me what is use of except clause? How it differs from not in clause?
What are the system database in sql server 2005?
What is function of ROLLUP ?
What is nolock hint in sql server 2008
What is normalization and what are the advantages of it?
What does it mean to normalize data?
what is a join and explain different types of joins? : Sql server database administration
Define indexes?
What is primary key and example?
What are the differences between union, intersect, and minus operators?
What are the steps to insert a table?
What is a field in a table?
When would you use it?
What is query parameter in ssrs?
Do you know hot add cpu in sql server 2008?
