SAP Knowledge Base Article - Preview

2149301 - Master database has unexpected growth in space usage - SAP ASE

Symptom

  • Master database has unexpected growth in space usage
  • sp_spaceused output displays increase in space usage in used_pages column

sp_spaceused syslogs

 name            total_pages     free_pages      used_pages      reserved_pages
 --------------- --------------- --------------- --------------- ---------------
 syslogs         515840          509178          2381            0             


sp_spaceused syslogs

 name            total_pages     free_pages      used_pages      reserved_pages
 --------------- --------------- --------------- --------------- ---------------
 syslogs         515840          506413          5144            0             


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP131

Product

SAP Adaptive Server Enterprise 15.7

Keywords

tablealloc, allocation page, 1105,  statistics, sysstatistics, sysqueryplans, systabstats , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.