Premium Content

Access "Free up database space"

Published: 01 Nov 2012

Archiving ERP tablespace data requires specialized tools and a close working relationship with the application's DBA. Enterprise resource planning (ERP) applications are demanding, consume increasing amounts of storage and computing resources, and usually need to be running 24/7. All of that translates into a complicated backup and recovery environment. ERP applications are typically the first to be replicated for disaster recovery and, in some cases, parts of the application databases are the first to be archived. An ERP app contains a treasure trove of data intricately tied to numerous critical processes that reflect the overall performance and health of a business. As more data is collected, the storage infrastructure can become strained, creating slower end-user response times, longer batch runs, shrinking backup windows and recovery tests that miss their recovery time objectives. To address this issue, a company will typically upgrade its ERP infrastructure, believing that more spindles, CPUs and I/O will fix the problem. Eventually, those enhancements ... Access >>>

Access TechTarget
Premium Content for Free.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

What's Inside

  • Columns
    • Storage Bin: Duplessie's theory of evolution

      Evolutionary changes in the storage world have opened the door to scores of smaller companies. Some of these startups have seized the opportunity, taking advantage of the current market dynamics. Good for them; but it's even better for you, with more choice and innovation than we've seen in a long time.

    • Hot Spots: Remote workers, stand up and be counted

      Remote-office workers need to share their experiences with corporate IT because there are many different issues associated with working remotely and a wide range of products to address those problems.

    • Best Practices: Balance workloads with RAID types

      Vendors will tell you how beautifully parity-based RAID works in their storage subsystems, making it almost unnecessary to use any type of striped/mirrored RAID protection. But if you don't match the workload profile of the application to how storage is provisioned in the array, you could wind up with a poorly balanced system.

    • Editorial: Who will run the storage shop?

      Who will run the storage shop?

More Premium Content Accessible For Free