SAP Knowledge Base Article - Preview

2007390 - Why did the time to dump a database increase after a lot of data was deleted from a database? - ASE


  • Dump database is slower after a large amount of space is freed.
  • After deleting rows from tables, truncating tables or dropping tables, backups of the database are taking much longer to complete.
  • Example: a database dump to 30 stripes at a compression level of 5 normally takes 2-3 hours. After dropping a large table, dump is now taking 6 hours.



SAP Adaptive Server Enterprise (ASE) All Versions


SAP Adaptive Server Enterprise all versions


backup, backupserver, slow, slower, longer, performance, dump, backup, sparse, empty, drop, truncate, delete, free , 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.