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 in brief how sql server enhances scalability of the database system?
What is difference between primary key and foreign key?
How can I create a report based on a query? : sql server management studio
what is difference between view and Dip.
what is the difference between Tabular and Matrix report?
Explain different types of lock modes in sql server 2000?
Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?
what are the new features introduced in sql server 2000? : Sql server database administration
Tell me what is the significance of null value and why should we avoid permitting null values?
Explain four layers of abstraction microsoft architectured?
What stored procedure can you use to display the current processes?
How do you delete duplicate records in sql server?
Can you leave a union at any time?
Does partitioning improve performance sql server?
Explain partitioned view?
