Though a database may be operational and performing effectively, there are often ways to improve this performance. True diagnosis requires an historical evaluation and a look at all of the vital signs as a whole (CPU utilization, memory utilization, paging frequency, backups, file system space utilization, etc.). The same holds true for the database. Key factors are analyzed generating concrete performance recommendations.
easyDBA offers a comprehensive analysis and a tuning of a full set of DBMS performance aspects: DB settings, queries, OS, middleware and storage. Our DB tuning services include:
- Heaviest SQL statement identification and tuning
- Resource contention identification
- Sotred procedures and Oracle PL/SQL tuning services
- RAC tuning
- Batch run analysis
- Assessment of applications
- Recommendations of new features