Interested to Buy Any Domain ? << Click Here >> for more details...
What is difference between process and thread?
Explain lazy writer funcationality.
- 2 Answers
- 8152 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How you provide security to cube? : sql server analysis services, ssas
How column data types are determined in a view?
What is the significance of master, tempdb and model databases?
How do we Backup SQL Azure Data?
Can sub report data source be different from that of the parent report?
How is sql used in sql server?
Explain cdc and sql injection?
What is snapshot report?
What is raid? : SQL Server Architecture
What are the filtered indexes?
how many layers of tcp/ip protocol combined of? : Sql server database administration
Explain powershell included in sql server 2008?
What is the fillfactor concept in indexes?
What is provisioning, billing and metering, and connection routing concepts in the service layer?
You have to store user responses of ‘yes’ and ‘no’ what kind of data type is best suited for this task?
