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 are the operating modes in which database mirroring runs?
Differentiate between mongodb vs. Sql server?
Why functions are used in sql server?
Where sql server user names and passwords are stored in sql server? : sql server database administration
What is read uncmmited?
How you can change the database name in SQL SERVER?
Is candidate a key?
What is function of master database?
What are .mdf files?
Do you know exporting and importing utility?
What do you understand by physical_only option in dbcc checkdb?
What is data source in connection string?
how to create a scrollable cursor with the scroll option? : Sql server database administration
What is application role in sql server database security? : sql server security
What is buffer cash and log cache in sql server?
