dbcc checkstorage requires a I/O buffer pool of one extent. Use sp_poolconfig to configure the pool size and verify that the pool has been configured properly. The pool size is stored in the dbcc_config table.
The following example shows how to use sp_poolconfig to set a 16K buffer pool for “master_cache” on a server configured for 2K logical pages. The named cache that is created for the master database.
1> sp_poolconfig "master_cache", "1024K", "16K" 2> go
(return status = 0)
The following example shows that the buffer pool for the private cache “master_cache” is set:
1> sp_poolconfig "master_cache" 2> go
Cache Name Status Type Config Value Run Value ------------- --------- -------- ------------ ------------ master_cache Active Mixed 2.00 Mb 2.00 Mb ------------ ------------ Total 2.00 Mb 2.00 Mb ================================================================= Cache: master_cache, Status: Active, Type: Mixed Config Size: 2.00 Mb, Run Size: 2.00 Mb Config Replacement: strict LRU, Run Replacement: strict LRU IO Size Wash Size Config Size Run Size APF Percent -------- --------- ------------ ------------ ----------- 2 Kb 512 Kb 0.00 Mb 1.00 Mb 10 16 Kb 192 Kb 1.00 Mb 1.00 Mb 10 (return status = 0)
For more information on sp_poolconfig, see the Reference Manual.
