| Information |
| Cache Type | Mixed |
| Cache Status | Active |
| Configured Size | 50.00 MB |
| Run Size | 50.00 MB |
| Overhead | 5.39 MB |
| Object bindings |
| Object name | Object type |
| icsa.dbo.pdc.pdc_ux | index |
| icsa.dbo.pdc.pdc_filename | index |
| 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 | 40.00 | 8.00 |
| DDL |
USE master
go
EXEC sp_cacheconfig 'pdc_cache','50.000M',mixed,strict
go
EXEC sp_poolconfig 'pdc_cache','10M','2K'
go
EXEC sp_poolconfig 'pdc_cache','2K','wash=2M'
go
EXEC sp_poolconfig 'pdc_cache','40M','16K'
go
EXEC sp_poolconfig 'pdc_cache','16K','wash=8M'
go