- When running dbcc checkstorage on a very large database, with size in TeraBytes (TB) range
- Having settings as suggested by sp_dbcc_evaluatedb and sp_plan_dbcc procedures
- The dbcc check will still fail with error 9952:
dbcc checkstorage (Very_Large_DB_name)
Checking Very_Large_test_DB: Logical pagesize is 4096 bytes
Msg 9952, Level 17, State 1:
Server 'ASE', Line 1:
Workspace 'scan_work_space' is too small to permit the CHECKSTORAGE operation to proceed.
Use sp_dbcc_alterws and sp_dbcc_updateconfig to correct the problem.
DBCC CHECKSTORAGE for database 'testdb' encountered an error. Some results may notbe available.
Correct the problems reported and reexecute the CHECKSTORAGE command.
SAP Adaptive Server Enterprise (SAP) 15.7 & 16.0
DBCC Checkstorage, Msg 9952 , message 9952 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Bug Filed
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.