Information

Cache Type	Mixed
Cache Status	Active
Configured Size	45.00 MB
Run Size	45.00 MB
Overhead	4.90 MB

Object bindings

Object name	Object type
icsa.dbo.observations	table

Pool

Pool name	Configured size (MB)	Run size (MB)	Wash size (MB)
2K I/O Buffer Pool	0.00	10.00	2.00
16K I/O Buffer Pool	0.00	35.00	7.00

DDL

USE master
go
EXEC sp_cacheconfig 'observations_che','45.000M',mixed,relaxed
go
EXEC sp_poolconfig 'observations_che','10M','2K'
go
EXEC sp_poolconfig 'observations_che','2K','wash=2M'
go
EXEC sp_poolconfig 'observations_che','35M','16K'
go
EXEC sp_poolconfig 'observations_che','16K','wash=7M'
go