Changing the Size of Memory Pools

Use sp_poolconfig to change the size of a memory pool, to specify the cache, the new size for the pool, the I/O size of the pool you want to change, and the I/O size of the pool from which the buffers should be taken.

If you do not specify the final parameter, all the space is taken from or assigned to the pool.

Related tasks
Decreasing the Size of a Cache