Logo

Home / Products

Products

Database Health-Check

Database Performance Analysis

Database Health-Check

This database analysis covers over 60 different topics that go from core configuration and version, security implementation and configuration. Finally, a detailed documentation is generated with the outcome of each check and a set of recommendations to address each issue.

Version / Parche Level Analisis

  • Databases and operating system Version Patch Level.
  • Database software version.
  • Critical database patches.
  • Etc.

Core database configuration

  • Database componentes
  • Database architecture, structure and configuration.
  • Optimizador configuration, gather stats strategy, etc.
  • Backup analysis: strategy, purge policy, backup testing, etc.
  • Database and Operating System log review – troubleshooting.
  • Etc.

Replication configurations

  • Architecture revision
  • Standby servers setup.
  • Analysis of replication implementation (streaming, cascade, synchronous, replication slots).
  • Analysis of how query conflicts are handled.
  • Etc.

Real Application Cluster configuration

  • Compatibility analysis - Clusterware - ASM - Databases.
  • RAC components revisión – Clusterware implementation and setups.
  • Home analysis.
  • Physical analysis - OCR files | Voting Disk | Archiving destinations, etc.
  • Cluster logs review – troubleshooting.
  • Etc.

Security Analysis

  • Analysis of vulnerabilities.
  • Analysis of default passwords.
  • Analysis of trivial accounts.
  • Revision of users with external authentication.
  • Analysis of granted privileges against the database dictionary and custom objects.
  • Analysis of the audit settings in place.
  • Etc.

Database Performance Analysis

This database revision contains a detailed analysis of the server and database behavior to determine the best approach to improve the response time of the database. The analysis covers from Overall performance review, hardware sizing to server CPU usage, server memory usage and server disk usage.

Response time methodology

The response time or uptime is the time the instance has been up and running. This time can be classified by 3 major components: service time (or cpu time), wait time and idle time.

Service time is the cpu time that has been consumed by processes of the instance to perform useful work (normally parsing and executing commands), wait time is the time the processes had to wait for some kind of resource to become free or for some task (for example a request to the OS) to complete, and idle time is the time the processes of the instance performed no work at all (They have been idle, waiting for something to do).

total uptime = service time + wait time + idle time


This methodology and comparing the results with the OS analysis is the key to successfully identifying the areas of improvements that will significantly improve the performance of your environment.

  • Database response time analysis.
  • Wait events classification.
  • Wait events top ranking.
  • Detailed analysis of each wait event and recommendations on how to specifically address each issue.

With the DB analysis, we also perform a detailed performance analysis from the OS (server) point of view. This analysis reveals how the OS resources are being used and determines the best approach to address database performance issues.

  • Operating System CPU Queues
  • Operating System CPU Utilization
  • Operating System - Memory
  • Operating System I/O – Service Time
  • Operating System I/O – Percentage Busy

Operating System I/O – Reads & Writes per Second