When the server starts, it begins by computing the upper limit of the BPool. This upper limit is the maximum size to which the server will allow the BPool to grow. On a non-AWE system, this size will be set equal to the amount of physical memory in the machine or to the size of the user mode address space minus the size of the MemToLeave region, whichever is less. (If the sp_configure max server memory setting has been changed from the default and is less than or equal to the amount of physical memory in the machine, it will override this computation.) So, if the system has 1GB of physical memory installed, the BPool will be sized to 1GB, provided max server memory has not been adjusted.

On an AWE system, the BPool upper limit will be ...

Get Guru's Guide to SQL Server Architecture and Internals, The now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.