"To compound this problem, many enterprises are in the midst of compliance initiatives that require the retention of more data for longer periods of time, as well as consolidation projects that result in significant data growth," said Charlie Garry, senior program director at Meta Group.
In terms of compliance alone, Sarbanes-Oxley, SEC 17a, HIPAA and a host of other rules have transformed information management into a minefield of potential liability.
Clearly, the legal ramifications of being without a way to archive information from databases can be grim. But there are production reasons, too: slow transactions, system outages; backup failures; and queries timing out as they have to search through millions of records.
|In terms of compliance alone, Sarbanes-Oxley, SEC 17a, HIPAA and a host of other rules have transformed information management into a minefield of potential liability.|
"The more data you have in production, the slower the database grows," said Luca Cotrone, systems analyst at Southwest Gas. "Users complain of queries taking a long time and you can run out of disk space."
The company has a total of 7 databases instances running: one for production, and others for training, QA, testing, development, special projects and a sandbox for patches, etc. All data from the production database is copied to the others. One Sun server houses the production and training database, while another Sun server hosts the other five instances. That server was particularly affected by the database bloat due to running out of disk space, and having less memory and slower CPU's than in the production system.
To solve these issues, Southwest Gas implemented Applimation Archiver by Applimation Inc. (New York, NY). The Oracle 8i database has stabilized at around the 100 GB mark. Archiving of one General Ledger table, for example, saved 18 GB. Searches are down from several minutes to a few seconds.
Continued on Page 2.