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 |
Where are full-text indexes stored?
What is the process of indexing?
How to download and install microsoft .net framework version 2.0?
what is the use of database index(apart from the last searching of records) and what is the use of composite key?
What does it mean to normalize data?
How connect excel to sql server?
What is Lock table in SQL?
What are the fixed server level roles? : sql server security
How to manipulate data from one table to another table ?
What are the differences between union, intersect, and minus operators?
How do I partition a table in sql server?
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID