Menu
Menu
One of the main problems encountered during IT service delivery is maintaining sufficient performance of IT systems. Most often, the only solution to performance problems is investing in larger, more powerful servers. However, this does not always produce the expected results, despite the high expenditure incurred. Instead of investments in hardware, performance problems can be much better solved by appropriate database tuning. In order to know where to apply tuning within the database, you need to locate bottlenecks and understand their causes.
Due to its intuitive interface, this tool is widely used not only by DBAs but also – different members of IT departments e.g. developers or application administrators, thereby facilitating cooperation within the organization and speeding up problem resolution.
The user can get straight to the root cause of the performance problem within just a few clicks. The outstanding ease of use of the Performance Monitor distinguishes it from its competitors.
The system does not install any software on the monitored databases. At 15-minute intervals it logs into the monitored databases and gathers performance statistics. The load it produces for monitored databases is unnoticeable
The architecture of the application uses the IIS web server to allow multiple users to access the application via a web browser. This significantly quickens deployment of Performance Monitor within the organization, as there is no need to install any client software on users workstations. Regardless of the number of application users, it does not create any more load for the monitored databases.
This tool allows performance comparison with previous periods or the baseline within a very broad range of dates – freely selected from the moment the system starts monitoring until present time. It allows verification of whether certain SQL queries which are causing bottlenecks now were behaving differently in the past. You can examine long-cycle trends to prevent performance problems in the future.
The whole philosophy of the tool is centered around finding the root causes of performance problems. The system allows for the easy comparison of data and has different cross sections, which enables quickly finding problematic SQL queries and understanding why they are causing performance issues.
The user receives an instant insight into whether the problem is on the side of an application, the database server, the database itself or its disk system. Using this tool will once and for all end disputes between suppliers who argue that the performance problem lies elsewhere.
The Performance Monitor allows you to quickly locate new SQL queries and changed execution plans for old queries which are the most probable source of the problems after the migration.
The vast majority of performance problems are caused by reading information from disk devices that take too long to load. Experience shows, that by using our tool, this allows for a decrease of data reads by up to 80%.
Monitoring a large number of databases can create substantial costs attached to the licenses of monitoring software. We offer our clients an “unlimited” license, which is extremely attractively priced and can be negotiated individually.
To have full monitoring, you don’t need to spend money on anything but the Standard Edition of Oracle. No Tuning Packs required. Performance Monitor works exactly the same way with the Enterprise Edition and the Standard Edition.
Performance Monitor allows for very precise analysis of the root causes of problems with latches. Several other tools enable the analysis of waits, but the ability to analyze latches makes the Performance Monitor a much more powerful tool.
* Specific for Performance Monitor for Oracle
Performance Monitor is updated at least 4 times a year. Customers have access to all updates when they have a license or maintenance service. With the upgrade to the latest version, the application will run faster and smoother. Each published version provides new functionalities that allow for easier management and performance improvement in the monitored database.
DBPLUS Performance Monitor is licensed per database instance
All details of every SQL query in the database, and full information about execution time, CPU, memory, I/O usage, etc.
Quick search of SQL queries causes the greatest load on the database
Very long history for each SQL statement with fully customized viewing period
Easy-to-use change plan finder for easily locating changed and ineffective execution plans
Easy-to-use new statements finder for easily locating new SQL queries
Highly customizable charts showing data in many different cross-sections
The dashboard allowS monitoring multiple instances from one location
Thorough analysis of waits and latches. Advanced trends analysis for predictive database tuning and capacity planning
Alerts via email when levels of certain parameters reach set thresholds
Exactly the same user interface for all databases
