| 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