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.

• Moving Space from the Memory Pool
  Use sp_cacheconfig to check the current configuration of the pubs_log cache.
• Moving Space from Other Memory Pools
  To transfer space from another pool specify the cache name, a “to” I/O size, and a “from” I/O size.