Interested to Buy Any Domain ? << Click Here >> for more details...
what is lazy writer?
- 1 Answers
- 8896 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 |
What is application role in sql server database security? : sql server security
Can a table have 2 primary keys?
What is best institute to Learn DotNET And SQL in chennai?
What is the function of inner join?
How to list all tables in the database using odbc_tables()?
What is full outer join in sql server joins?
How to create a user to access a database in ms sql server using "create user" statements?
How to delete exactly duplicate records from a table?
what are cursors? : Sql server database administration
What is fill factor and pad index?
How to disable a login name in ms sql server?
What is the purpose of the tempdb database?
-
Oracle (3253) - 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)
