Information

Cache Type	Mixed
Cache Status	Active
Configured Size	200.00 MB
Run Size	200.00 MB
Overhead	21.53 MB

Object bindings

Object name	Object type
controls	database

Pool

Pool name	Configured size (MB)	Run size (MB)	Wash size (MB)
2K I/O Buffer Pool	0.00	50.00	10.00
16K I/O Buffer Pool	0.00	150.00	30.00

DDL

USE master
go
EXEC sp_cacheconfig 'controls_che','200.000M',mixed,strict
go
EXEC sp_poolconfig 'controls_che','50M','2K'
go
EXEC sp_poolconfig 'controls_che','2K','wash=10M'
go
EXEC sp_poolconfig 'controls_che','150M','16K'
go
EXEC sp_poolconfig 'controls_che','16K','wash=30M'
go