To change the size of an existing cache, issue sp_cacheconfig, specifying a new total size for the cache. When you increase the size of a cache, all the additional space is added to the pool. When you decrease the size of a cache, all the space is taken from the default pool. You cannot decrease the size of the default pool to less than 512K.
