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
How to test subquery results with the exists operator?
Distinguish between nested subquery and correlated subquery?
What are subqueries in sql server? Explain its properties.
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
What are the purpose of Normalisation?
How to get all stored procedures in sql server?
What is partition in sql server?
What is Cross Join and in which scenario do we use Cross Join?
How to run queries with sql server management studio express?
What is cross join in sql server joins?
what is raid? : Sql server database administration
How to transfer data from a cursor to variables with a "fetch" statement?
What is star, snowflake and star flake schema? : sql server analysis services, ssas
How to query multiple tables jointly?
Why Master database is required?
