what is lazy writer?
Answer / 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 |
How to Run a Query on a Remote SQL Server?
How to find tables without indexes?
What is a cursor, index in sql?
How adventureworkslt tables are related?
what is the difference between a primary key and a unique key? : Sql server database administration
How optimize sql query with multiple joins in sql server?
whats the maximum size of view state??
What is the datatype returned by count(*)
22 Answers 247Customer, Asian CERC,
Explain the steps to create and execute a user-defined function in the sql server?
What are the extra roles available in msdb? : sql server security
What is an example of a primary key?
What do you understand by integration services in sql server?