Once the procedure cache and the data cache are configured there is no division or left over memory.
The procedure cache – used for stored procedures and triggers and for short-term memory needs such as statistics and query plans for parallel queries.
The data cache – used for data, index, and log pages. The data cache can be divided into separate, named caches, with specific databases or database objects bound to specific caches.
Set the procedure cache size to an absolute value using sp_configure. See the System Administration Guide for more information.
