Guru's Guide to SQL Server Architecture and Internals, The

Knowledge Measure

1. The BPool is the pool from which most memory allocations are made within SQL Server. What region is set aside for external consumers such as OLE DB providers that run in-process with the server?

2. Which of SQL Server's five memory managers manages memory related to connections?

3. How often does the lazywriter process run?

4. What Perfmon counter reflects the total amount of committed virtual memory within a process?

5. Describe, in general terms, the two main functions of the lazywriter process.

6. True or false: On all releases of SQL Server 2000 and later, allocations of 8KB or less always come from the BPool.

7. True or false: Allocations made by an xproc via the ODS srv_alloc API function are always allocated from the MemToLeave region, regardless ...