Serco, Inc. is a leading provider of professional facilities management services focused on the federal government. It is an international service company with employees around the world, employing more than 11,000 dedicated professionals in more than 100 locations across North America.
Diamond Technology was selected to support Serco Inc’s Transportation Group for IT/Database Services in support of the SFMTA’s San Francisco Parking Meter (SFPM) management application. This infrastructure consists of 2 Oracle databases, and 4 MS SQL Server databases housing critical traffic and transportation information and services. DTI was assigned the following specific tasks and responsibilities.
REDO LOG ERRORS
The SFPM Oracle database had been experiencing a number of Redo Log errors that had been of some concern.
DTI’s diagnosis and concern was, as the number of redo logs increase for a database, it becomes less likely the writing of the redo logs is going to keep up with the archiving process. Heavy transaction data activity will switch the redo logs, but the archive process may not be fast enough to keep up, as it tries to copy redo logs to the archived log files. This could stop all the database transactional change activity, until a redo log can be archived and recycled. If it has not yet been archived, a redo log will not be recycled. This would result in a stoppage of all database activity until all required archiving is completed and a redo log is cleared for reuse.
When there is high data activity and a redo log is too small, this could result in excessive switching. Once again, this could halt the database activity because the archiving process may not be able to keep up,
PREVIOUS DATABASE CRASHES
As the SFPM database had already experienced, when a problem prevents a database from continuing to run, it’s called a database instance failure. An instance failure can be due to factors such as an operating system crash, or be the result of a hardware problem, power outage, or another type of software problem.
AGE OF SFPM DATABASES
The SFPM database system was 9+ years old, and has had various software updates and changes made to the main application.
As databases begin to age past eight, ten, twelve plus years, they become increasingly at risk of experiencing a number of age-related problems. Problems can stem from OS compatibility issues. Slow performance and database crashes can begin to originate from data growth issues, index growth issues, fragmentation issues, and more. Aging databases may also suffer from data loss caused by incomplete backup and restore operations, update errors, media failure, user error, unintended changes in the database structure, and other related maintenance issues.
DTI recommended and implemented a database management plan to, not only significantly reduce the chances of database performance problems and crashes, it also enabled DTI to provide informed guidance regarding client requested system improvements and recommendations. The results included the significant reduction in database outages, batch job errors, and the proactive identification and prevention of system issues. Additionally, the client reported faster problem resolution when problems did occur. The provisioning of services included the following:
Our service team can save your company valuable time and money by making your data systems faster and more efficient with solutions that can integrate separate data sources, systems, and processes that may be repetitive, time consuming, and unnecessarily tedious.
Copyright © 2024 Diamond Technology Services. All Rights Reserved
