SAP Sybase ASE: Shrinking a Database for Storage Optimization

    By: Mr. Vinod Chandran on Oct 01, 2013

    Traditional database growth has been attributed to various factors – indexes that are built in the database, backups, as well as compliance requirements such as Sarbanes Oxley and HIPAA that warrant the need for retaining historical data. These factors in addition to operations such as ‘select into’, ‘alter table’, and ‘parallel create index’ often require extra log space. Once these triggering events are completed, the extra allocated space becomes a wasted resource as well as a source of I/O bottlenecks causing performance problems and hampering the availability of business critical information. Although the burden of providing sufficient storage to keep up with growing data lies in the hands of IT personnel, DBAs have equal responsibility to ensure queries run fast and the database is well-designed and tuned with data spread efficiently across different disk devices to help prevent storage related bottlenecks and issues.

    SAP Sybase Adaptive Server Enterprise SP100 (SAP Sybase ASE SP100) offers a distinct advantage for handling disk space usage: Shrink database functionality helps to optimize disk storage use by the database while providing improved cost of operations and efficient data handling for better query performance.

    Login to read the article. Not a member? Create a free account!

    Released: October 1, 2013, 10:05 am | Updated: January 27, 2014, 6:20 pm
    Keywords: ASE DBA Article | Technical Journal | ASE 15.7 SP100 | Data Management | DBA | shrinkDB | Vinod Chandran




    Copyright © 2014 ISUG-TECH. All Rights Reserved
    All material, files, logos and trademarks within this site are copyright their respective organizations

    Terms of Service - Privacy Policy - Contact the Help Desk