2025063 - DBCC checkstorage raises Error 9952 when the dbccdb database is configured using the suggested scan size and the user database is 7.4 TeraBytes in size or greater - SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2025063 - DBCC checkstorage raises Error 9952 when the dbccdb database is configured using the suggested scan size and the user database is 7.4 TeraBytes in size or greater - SAP ASE

Symptom

Error raised:

dbcc checkstorage (testdb)
Checking testdb: Logical pagesize is 4096 bytes
Msg 9952, Level 17, State 1:
Server 'ase16', Line 1:
Workspace 'testscan_ws' 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 not
be available. Correct the problems reported and reexecute the CHECKSTORAGE command.

DBCC Checkstorage will fail with Error: 9952 when:

  • The user database is at least 7.4 TeraBytes
  • The current scan workspace is using the scan workspace size suggested by sp_dbcc_evaluatedb
  • Scan workspace is less than 2.5 x the suggested size

Two failing configurations:

User database = 7.4 TeraBytes  

1> sp_dbcc_evaluatedb testdb
Recommended values for workspace size, cache size and process count are:
 
Database name : testdb
                                                 current         suggested
scan workspace size :                90G                 90G
text workspace size :                 23G                  23G
cache size          :                   7168M             1280K
process count       :                      4                     2
  
User database  = 10 TeraBytes 

1> sp_dbcc_evaluatedb testdb
Recommended values for workspace size, cache size and process count are:
 
Database name : testdb
                                                 current         suggested
scan workspace size :              300G               123G
text workspace size :                  31G                 31G
cache size          :                    7168M            1280K
process count       :                       4                    2

 




Read more...

Environment

  • SAP Adaptive Server Enterprise (SAP) 15.7.x All Versions   
  • SAP Adaptive Server Enterprise (SAP) 16.0 GA 

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

DBCC Checkstorage,Msg 9952 , KBA , BC-SYB-ASE-CE , ASE Cluster Edition (Standalone) , Problem

About this page

This 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.