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.

What is buffer cash and log cache in sql server?

0 Answers  

---

Explain relational data?

0 Answers  

---

What is a trigger in sql server?

0 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

Can a function call a stored procedure in sql server?

0 Answers  

---

Can sql servers link to other servers like oracle?

0 Answers  

---

Explain nested join?

0 Answers  

---

What is meant by referential integrity?

0 Answers   Blue Star,

---

What is the use of set nocount on/off statement?

0 Answers  

---

What structure can you implement for the database to speed up table reads?

0 Answers  

---