Database Performance Analyzer, or DPA for short, was developed to change the way database performance is managed. By putting the focus on application end-user wait time, you can quickly deliver performance improvements that get noticed.
Database Performance Analyzer monitors your registered databases 24/7. Critical alerts are displayed on the dashboard, and can be delivered to your smartphone or email without overloading your inbox. Most major database types are supported, and within just four clicks, you can drill down to the root cause of most database performance problems.
We pioneered response time analysis, which focuses on the time between a query request and a query response. This time can be broken into discrete steps called ‘waits.’ DPA monitors these waits and identifies those that have the biggest impact on database performance.
Database Performance Analyzer makes performance analysis accurate and fast. Just click on the big bars to drill down to the root cause of the problem. These bars represent the total time application users wait over the course of a month. Information is collected every second, and automatically condensed over time.
Let’s start by drilling into a specific day. Each query is represented by a unique color. Hovering over the bar gives us a detailed view of the query, including query text, and total wait time. The hour view pinpoints the query, total response time, and the specific wait event or type, giving you actual information to resolve these issues fast. These tabs provide additional information on top waits, programs, and blockers.
DPA can easily be adapted to meet your specific requirements by using custom reports, alerts, and metrics. You can even show baselines for the resource metrics to see if something is performing outside the norm. Here you can see that there is a disc I/O related wait and how much it's contributing to the overall performance of the application.
The latest release of Database Performance Analyzer features an entirely new section that you can use to identify if a specific problem is I/O related or not. To drill into I/O further, click on the 'Storage I/O' link to determine the read/write performance of database files.
Here, much like the previous trend screen, you can click on the big bars to isolate problems. Once you get to an hour's detail, you can select the top file and be able to see multiple views. Now, you have clear evidence to show your storage admin exactly when I/O slowdowns are impacting database performance, and precisely how the slow application performance can be attributed to the I/O subsystem. This puts an end to finger-pointing within the IT departments.
Unlike other monitoring technologies, that force you to choose between detailed monitoring and load on the monitored servers, Database Performance Analyzer's agentless architecture monitors 24/7, with less than 1% load.
Deliver results that get noticed. Database Performance Analyzer will make you a better database performance expert.