Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


what is lazy writer?



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

Post New Answer

More SQL Server Interview Questions

What are SSL and TSL protocols?

0 Answers   Wipro,


What are the requirements for sql server 2016?

0 Answers  


What are the underflow and overflow behaviors on float literals?

0 Answers  


What is acid mean in sql server?

0 Answers  


What is the Control Flow in SSIS

0 Answers   HCL,


Explain transaction server auto commit?

0 Answers  


What's the information that can be stored inside a bit column?

0 Answers  


What is the difference between implicit and explicit transaction?

0 Answers  


can any one answer this query,thank you in advance Table 1 has 2 columns: EmployeeId, T shirtsize(values can be 1,2,3) Table 2 has 2 columns: EmployeeId, Region Write SQL to Find the region which has the largest number of people with Tshirt size=3

15 Answers   Google,


I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?

0 Answers   IBM,


What is equi join with example?

0 Answers  


Explain what you mean by 3 tier architecture.

0 Answers   TCS,


Categories