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.

Can an automatic recovery be initiated by a user?

0 Answers  

---

What are SSL and TSL protocols?

0 Answers   Wipro,

---

What is tcl in sql server?

0 Answers  

---

what is extended StoreProcedure ?

3 Answers   Satyam,

---

How to rebuild master databse?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What is the default server name for sql server?

0 Answers  

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

what is procedure in sql?

2 Answers   Millennium, SQL,

---

Tell me what is the order in which the sql query is executed?

0 Answers  

---

What is the difference between ‘having’ clause and a ‘where’ clause?

0 Answers  

---

What are the advantages dts has over bcp?

0 Answers  

---