Our team of experts will analyze your system and work with your team to:
- Improve system performance & response time
- Minimize downtime & expenses
- Make the best use of current hardware & software
- Achieve your scalability & performance goals
- Reduce further risk of poor performance
Systems & Performance Analysis Case Studies
||Application & Database Tuning
A local client providing an Internet application that allows external customers to scan,
archive and retrieve documents, experienced an increase in the volume of business documents scanned by the application,
which resulted in unacceptable response times.
||Celeritas conducted a thorough performance evaluation, including a review of the Oracle database, database indexes,
SQL queries, and the J2EE architecture. The Celeritas Database Configuration Report and the
Oracle Statspack utility were used to evaluate the database performance.
Once the resource-intensive SQL statements were identified, the Oracle Explain Plan utility was
used to tune the SQL statements.
Several of the SQL statements were optimized to attain sub-second response time compared to the original
2-3 minute response time.
||Oracle Performance Review
A local manufacturing company was experiencing major growth, which was taxing their current
Lilly Manufacturing Application, running on an Oracle database.
Celeritas provided Oracle DBA support to review the
current Oracle database, and proposed and delivered recommendations that resulted in dramatic performance improvements,
allowing for an increase in the number of users the system could support. Celeritas utilized our
custom Database Configuration Report in combination with Oracle Statspack to
identify and resolve the performance issues.
|A large Midwestern utility company migrated several custom-developed applications from
Microsoft SQL Server to a Sun Solaris/Oracle platform. This new robust environment was required because of
application enhancements and the need to store, query, and analyze terabytes of data.
Many of the SQL queries within the custom application were not performing well after the migration
because they were originally written specifically for SQL Server. Celeritas provided assistance with
troubleshooting, identifying, tuning and in some cases, completely rewriting queries. This tuning drastically
improved performance and resulted in much better response times than in the original environment.
Contact Us |
Oracle Consulting |
Clustering/HA Systems |
Shared Services |
Sarbanes Oxley |
System Administration |
Copyright © 2006-2012 - Celeritas Technologies, LLC - All Rights Reserved
One or more products are covered under one or more of the following patents:
US Patent Nos. 6,343,290, 6,725,032, and 7,090,457. Other patents pending.