Preventing Database Bloat With Archiving
Best practices in database archiving help maintain healthy disk-space capacity and prevent performance problems.
Computerworld - Like waistlines, databases almost always grow much larger than their owners ever imagined. Instead of too many carbs, it's a regular diet of stodgy and unnecessary transactional information that leads to database obesity. Serious health problems can result, such as disappearing disk space, poor performance and screaming users upset about slow access rates or queries timing out.
"Our overweight database was months away from crashing due to exceeding our production disk-space capacity," says Larry Cuda, global data archiving and migration project leader at Kennametal Inc. in Latrobe, Pa. "Management determined that we could no longer just keep throwing more disks at the problem."
His SAP database was swelling at a rate of 27GB per month until Kennametal pared it down using eCONtext from Ixos Software AG in Grasbrunn, Germany. Transactions that used to take six seconds now take one, and the company saves an estimated $700,000 annually in terms of hardware acquisition costs alone, according to Cuda. The database maintains a trim 2TB figure, with another terabyte residing in rapid-access archives. The company has an HP-UX 64-bit environment for its SAP ERP applications as well as its Oracle 8.1 database.
With so many competing production demands, and differing U.S. and international data retention regulations to consider, archiving database information is never a quick fix. Companies must decide what they should archive, how they should go about it, which tools are available and which best practices apply.
According to Meta Group Inc., data is growing at a rate of 125% per year, yet up to 80% of this data remains inactive in production systems, where it cripples performance. "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," says Charlie Garry, senior program director at Stamford, Conn.-based Meta Group.
A laundry list of regulations makes any archiving endeavor an extremely complex affair: The Sarbanes-Oxley Act, SEC Rule 17a, the Health Insurance Portability and Accountability Act and a host of other rules have transformed information management into a minefield of potential liability.
The legal ramifications of not having a way to archive information from databases can be grim. But there are also production reasons for formulating and activating an archiving strategy rapidly. Apart from running out of disk space as Kennametal experienced, companies report problems such as total system outages when the database requires too much processing, backup failures when there's too much data to back up in the available window,
- 15 Non-Certified IT Skills Growing in Demand
- How 19 Tech Titans Target Healthcare
- Twitter Suffering From Growing Pains (and Facebook Comparisons)
- Agile Comes to Data Integration
- Slideshow: 7 security mistakes people make with their mobile device
- iOS vs. Android: Which is more secure?
- 11 sure signs you've been hacked
- What Datapipe customers need to know about the new PCI DSS 3.0 compliance standard This handy quick reference outlines what PCI DSS 3.0 is, who needs to be compliant and how Alert Logic solutions address the new...
- The 12 PCI DSS 3.0 requirements addressed by Peer 1 Hosting This handy quick reference outlines the 12 PCI DSS 3.0 requirements, who needs to be compliant and how Alert Logic solutions address the...
- Defense Throughout the Vulnerability Life Cycle This whitepaper provides insight into how to leverage threat and log management technologies to protect your IT assets throughout their vulnerability life cycle.
- The Critical Role of Support in Your Enterprise Mobility Management Strategy Most business leaders underestimate the importance of tech support when they choose an EMM solution. Here's what to put on your checklist.
- Live Webcast Best Practices for the Hyperconverged Enterprise Network To the Age of Constant Connectivity and Information overload
- Live Webcast Unmasking the Differences between Consumer and Enterprise File Sync & Share The consumerization of IT combined with the rapid pace of the modern mobile workplace is forcing enterprise IT teams to evaluate file sync...
- Live Webcast Government Agency Webifies Outdated COBOL Applications Let this CTO tell you how his agency converted 1980s-era green screens into an e-filing portal for the 100,000 cases handled each year...
- The New Way to Work Knowledge Vault This Knowledge Vault focuses on how, in today's increasingly virtual world, it's more important than ever to engage deeply with employees, suppliers, partners,...
- Getting Ready for BlackBerry Enterprise Service 10.2 Find out how BlackBerry® Enterprise Service 10 helps organizations address the full spectrum of EMM challenges, while balancing the needs of both the... All Applications White Papers | Webcasts