Interested to Buy Any Domain ? << Click Here >> for more details...
what is lazy writer?
- 1 Answers
- 8830 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Write a sql query to sort on different column name according to the parameters passed in the function?
Can you explain different types of joins?
What is a view and what are its advantages?
What is difference between views and stored procedures?
Difference between primary key and clustered index?
How can you stop stored procedures from recompiling?
How make remote connection in database?
How to delete an existing database user?
what are batch in sql server?
What is clr ddl trigger?
What is meant by Active-Passive and Active-Active clustering setup?
What is Right Outer Join?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
