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 for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.