What is difference between process and thread?
Explain lazy writer funcationality.
Answers were Sorted based on User's Feedback
Answer / sachin nandanwar
Its a rubbish answer what adesh has posted.
Lazy writer and checkpoints are NOT related to each other.
Lazywriter will come into picture only when there is memory
pressure by changing the size of buffer pool or when it
periodically finds dirty pages which have not been used for
a while and flushes those pages to the hard disk.It drops
the pages from the buffer cache to free the cache.
Checkpoint on other hand also checks for dirty pages and but
will not drop pages from the cache instead will mark the
page clean in the cache after flushing it to disk.The
primary purpose of checkpoint is to keep the recovery time
as low as possible and not memory management.
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / adesh saunakiya
Lazy writer function is to write the data pgae from buffer
log to Master data file in cordination with checkpoint
because data page having counter which is refresh it self
from 0 to 1 as the data page is commited its counter is set
to 1 and lazy writer scan the datapage continuosly as it
set to 1 it free the memory in buffer log and save that
page in to master data file physically.
i think thread are the part of a process.
Is This Answer Correct ? | 0 Yes | 1 No |
Is t sql the same as sql server?
what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?
What is sql server agent and what are the two modes of authentication in sql server?
What is constraints and its types?
What are the different index configurations a table can have?
What is blocking and how would you troubleshoot it?
Explain transaction server implicit?
Name 3 of the features that the sql server built-in function loginproperty performs on standard logins? : sql server security
What are the pros and cons of creating extended stored procedures?
What is molap and its advantage? : sql server analysis services, ssas
How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?