Tektronix, Inc. is a technology company focused on providing test, measurement, and monitoring solutions to enable and sustain the explosive growth of global communications networks and Internet technologies.
A leader in its target markets, Tektronix is universally recognized for high-quality products, technology innovations, and partnership with customers. The company holds more than 1,000 patents worldwide and receives approximately 60 more each year. Tektronix is dedicated to leveraging this vast store of technology and expertise to deliver products that allow its customers to design microprocessors and computers and deploy communications systems that drive the ongoing revolution in global communications networking.
Business need
Tektronix faced issues related to data growth, data availability, system performance and system availability in a 24 x 7 environment.
To address these challenges, Tektronix implemented a worldwide data archive solution from HP in June of 2002. This archive solution proved invaluable in its efforts to lessen the burden of data growth, mitigate performance problems in the company’s OLTP system and still satisfy worldwide financial and reporting requirements.
Solution overview
Tektronix implemented a proof of concept and testing that provided convincing evidence of the efficacy of the HP StorageWorks Reference Information Manager (RIM) for Databases solution. In particular, it established:
RIM for Databases is a robust, reliable product that solves Tektronix’s archiving issue.
The solution can be used to archive custom data.
The archived data was available in the archive instance without data loss.
There were measurable performance improvements.
Significant space savings could be realized.
Based on the proof of concept results, Tektronix elected to proceed with a full RIM for Databases implementation. To have the fastest impact on escalating application data growth, Tektronix prioritized the implementation of the Oracle Application archives based on their current space usage.
Results
The initial proof of concept made a clear argument for the validity of an application data management solution with the relocation of historical data into an online archive. The subsequent results of the HP RIM for Databases implementation and archive operations further reinforced this conclusion.
Based on Tektronix’s firsthand experience, the company has determined:
Purging data improves system performance
Purging data reduces database server resource consumption by:
o Reducing hardware upgrade costs o Consistently executing batch jobs on time o Improving online response time o Reducing disk growth
RIM for Databases reduced the cost and time for additional development and test environments.
RIM for Databases reduced backup and copy time as well as disaster recovery time.
RIM for Databases acts as an extension of Oracle Applications to eliminate the need for additional end-user training.
Printable version
