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
why would you use sql agent? : Sql server database administration
How to install sql server 2005 express edition?
Describe the functionalities that views support.
What method is used by the Command classes to execute SQL statements that return single values?
What is the difference between push and pull subscription? : sql server replication
How can we check the sql server version?
How to convert a table data in XML format in sql server?
How do indexes help, types?
How to select an exiting database using mssql_select_db()?
What are horizontal and vertical scaling?
When is the use of update_statistics command?
what is the difference between count(*) and count(1) ?
How to handle error or exception in sql?
How to disable triggers using "disable trigger"?
How to get the number of affected rows?
