tempdb_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

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

DDL

USE master
go
EXEC sp_cacheconfig 'tempdb_cache','50.000M',mixed,strict
go
EXEC sp_poolconfig 'tempdb_cache','50M','2K'
go
EXEC sp_poolconfig 'tempdb_cache','2K','wash=10M'
go