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 to resolve the orphan use problem? : sql server security
What are the purposes and advantages stored procedure?
What is the index requirement in SQL Azure?
What are the disadvantages of primary key and foreign key in SQL?
explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What happens if ntwdblib.dll is missing on your machine?
How you can add messages to the nt event log from within a stored procedure?
Can you leave a union at any time?
What is a view and what are its advantages?
Does sql server 2000 clustering support load balancing?
When we should use and scope of @@identity?
Where can you add custom error messages to sql server?
What is single-user mode?
What is sql collation?
Explain what stored procedure sp_replcounters is used for? : sql server replication