Information

Cache Type	Default
Cache Status	Active
Configured Size	371.19 MB
Run Size	371.19 MB
Overhead	40.25 MB

Object bindings

Object name

Object type

Pool

Pool name	Configured size (MB)	Run size (MB)	Wash size (MB)
2K I/O Buffer Pool	0.00	121.19	24.24
16K I/O Buffer Pool	0.00	250.00	50.00

DDL

USE master
go
EXEC sp_cacheconfig 'default data cache','371.189M',default,strict
go
EXEC sp_poolconfig 'default data cache','121.189M','2K'
go
EXEC sp_poolconfig 'default data cache','2K','wash=24.2363M'
go
EXEC sp_poolconfig 'default data cache','250M','16K'
go
EXEC sp_poolconfig 'default data cache','16K','wash=50M'
go