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 7000 15254 7000 7000 memory pages(2k) dynamic
The amount of memory used for the procedure cache is 30.508MB (that is, 15254 2K pages). To set the procedure cache to a different size, issue:
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
