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

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

Symptom

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

Read more...

Environment

SAP Adaptive Server Enterprise (ASE) All Versions

Product

SAP Adaptive Server Enterprise all versions

Keywords

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