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?

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

How often does the lazywriter process run?

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

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

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

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

What standard COM interface is used within SQL Server to manage individual memory allocations?

Which of the five memory managers is the only one the lazywriter can cause to free allocated pages?

On a system with 512MB of physical memory and a SQL Server startup parameter of -g768, what will be the maximum size to which the BPool can grow?

What Win32 API function is used by the lazywriter process on Windows 2000 to check the available physical memory in the machine?

True or false: Because UMS workers are often allowed to perform the work of the lazywriter process, the dedicated lazywriter often finds little to do when it runs on an instance of SQL Server installed on the Windows NT family of the Windows operating system.

Why is the virtual memory address space for the MemToLeave region reserved at system startup?

On a four-way SMP system, how many BPool free list partitions will SQL Server create?

What command line parameter can you pass into SQL Server to adjust the size of the MemToLeave region?

What operating system privilege must the SQL Server startup account have in order to make use of AWE memory?

True or false: When you configure SQL Server to use AWE memory on a system with less than 3GB of physical memory, the server will refuse to start and log an error in the system error log.

What mechanism does SQL Server use to track committed pages in the BPool?

What mechanism does SQL Server use to locate a data page in the BPool using its database ID, file number, and page number?

How many total reservations can be made at system startup to reserve the BPool?

On a SQL Server with 2GB of physical memory, a startup parameter of -g512, and a max server memory setting of 384, what will be the maximum size to which the BPool can grow?

By default, how much of the MemToLeave pool is set aside for thread stacks?

True or false: Because memory allocations by in-process COM objects that are 8K or less come from the BPool, they are automatically freed when the object is destroyed.

True or false: When AWE memory is being used by SQL Server, the physical memory behind the BPool is locked and will not be available to other processes.

True or false: By default, the lazywriter process tries to keep at least 384MB available for the MemToLeave region within the SQL Server process.