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 size of the dbcc checkstorage buffer pool is the page size multiplied by 16. The dbcc checkstorage buffer pool requirements for the different page sizes are:
2k page server) * (8 extents) = 16k buffer pool
4k page server) * (8 extents) = 32k buffer pool
8k page server) * (8 extents) = 64k buffer pool
16k page server) * (8 extents) = 128k buffer pool
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 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.
