Storage Management Strategies for the CIO
Access "Free up database space"
This article is part of the Vol. 6 No. 2 April 2007 issue of Backup overhaul: From a mainframe to an open-systems environment
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.
What's Inside
Features
-
- New laser tech yields bigger disks
- Backup book packed with quips and tips
-
Survey Says: Measuring storage team productivity
Measuring storage team productivity
-
L.L.Bean overhauls its backup process
With mainframe constraints slowing down its backup, L.L.Bean's IT group created a three-phase initiative to overhaul its entire approach to mainframe and open-systems backup and recovery.
- New tools trim primary data
-
Snapshot: Users big on centralizing remote offices
Users big on centralizing remote offices
-
- Disk drive failure rates: Fact or fiction?
- Hospital's ills cured by IBM setup
- Snapshots stymied in virtual world
-
Unsnarl port traffic
Configuring the number of ports on storage arrays and switches shouldn't be a guessing game that results in an excess of ports and a big dent in your budget. To properly size a switch or storage array, you need to analyze the average and peak bandwidth requirements of each device. Monitoring current utilization rates will help you determine effective bandwidth requirements.
-
New connections: SAS and iSCSI HBAs
Serial-attached SCSI and iSCSI host bus adapters (HBAs) represent the latest in server-to-storage connectivity technologies. Tailored to specifically address the needs of two emerging storage protocols, these new HBAs can ensure that performance isn't sacrificed when one of these alternatives to Fibre Channel storage is deployed.
-
Free up database space
Database archiving is critical to the long-term management of an enterprise resource planning (ERP) application. Archiving can shorten backup windows, speed recoveries and improve the database's overall performance. But effective archiving means carefully selecting the data to be removed from the production application and moved to secondary storage, and ensuring that it remains available and adequately protected.
-
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?
-
Storage Bin: Duplessie's theory of evolution
More Premium Content Accessible For Free
How to improve your virtual server storage setups
E-Zine
One of the biggest challenges of building a virtual server infrastructure is fine-tuning the storage that supports the virtual machines. Having ...
Rethinking the way storage architectures are packaged and presented
E-Zine
Cloud storage, virtualization and the growth of unstructured data have contributed to the way storage architectures are built and used. Virtual ...
Archiving stays active with LTFS and the cloud
E-Handbook
While the concept of data archiving has existed for decades, archiving practices that were once considered standard are becoming inadequate. Factors ...