pdc_cache

 

Object Type

Datacache

Datasource

IPMA

Database

N/A

 

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