Databases Reference
In-Depth Information
➤
Checkpoints occur automatically, roughly every minute, and provide the starting point for
recovery.
➤
The lazy writer maintains space available in cache by l ushing dirty pages to disk and
keeping only recently used pages in cache.
➤
When a database is using the full recovery model, full backups will not truncate the
transaction log. You must coni gure transaction log backups.
➤
Tasks are generated to provide the context for a unit of work executed in a session. Worker
threads handle the execution of work within a task, and a scheduler is the mechanism by
which threads are given time on a processor to execute.
➤
The SQLOS is a framework used by components in SQL Server for scheduling, I/O, and
memory management.
Search WWH ::
Custom Search