procedure cache size specifies the size of your procedure cache in 2K pages, regardless of the server’s logical page size. For example:
1> sp_configure "procedure cache size"
Parameter Name Default Memory Used Config Value Run Value Unit Type -------------------- ------- ----------- ------------ --------- --------------- --------- procedure cache size 3271 6914 3271 3271 memory pages(2k) dynamic
The amount of memory used for the procedure cache is 8.248MB. To set the procedure cache to a different size, issue the following:
sp_configure "procedure cache size", new_size
This example resets the procedure cache size to 10000 2K pages (20MB):
sp_configure "procedure cache size", 10000
