O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required