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