Database Performance Optimization

Absolutely yes! Our philosophy of operation assumes that the services offered to Clients are ALWAYS financially beneficial for them, no matter how many hours we work on the solution. We only charge if we deliver the agreed level of performance improvement. In this way, cooperation with DBPLUS is 100% risk-free.

The optimization service is a one-time performance improvement (performance on demand) and is the best option for systems that have lost performance after some time of operation, but are not subject to continuous development. When your system is constantly being modified to implement new functionalities and keep up with the ever-changing business environment, then a comprehensive performance management service is a better choice because one-time changes to improve performance may not work well after subsequent system updates.

Performance Monitor gives us very accurate information about the execution times of every single SQL query in the database along with information about CPU usage and the amount of data exchanged during I/O operations. Thanks to more than 15 years of experience of our experts based on information from the application, we can predict with very high accuracy how much the performance of the database can be improved. The accuracy of our estimates is so high that we are not afraid to provide customers with a guarantee of achieving certain parameters of database performance.

The service of one-time performance optimization depending on the needs of the Customer is performed remotely or locally at the place indicated by the Customer. On the other hand, the comprehensive performance management service is performed only remotely by the DBPLUS monitoring center. In this way, we are able to ensure consistent performance for the duration of the contract.

Each service requires prior software installation Performance Monitor. Performance information collected from the moment the monitoring is started. In order to perform the service as best as possible, we recommend a minimum of several days of operation of the application on the monitored database and only after that we proceed to perform the services.

The database performance optimization service includes:

1. Preparation of a summary containing information about basic performance metrics such as: query duration, CPU utilization or statistics of readings from disk devices. As part of the analysis, DBPLUS administrators determine the percentage level of optimization that can be achieved by following the recommendations and recommendations prepared by DBPLUS.

2. In the second stage, we prepare a detailed report containing the necessary changes that will improve the performance of the database as a result. The report provides a detailed analysis of the top queries with a recommendation to improve their performance that can be achieved without interfering with the application code. The report also includes information about bottlenecks and how to remove them (e.g. high level of blockages).

3. after the implementation of the recommendations, the Client receives a final report on which the results of the implemented changes are visible. Comparison of database performance before and after implementation of recommendations.