Traditional application performance management tools provide clues about performance issues, but they might not help you find actual root causes. SolarWinds® Database Performance Analyzer is a powerful monitoring tool that helps you quickly discover the source of your application performance issues.Improving Application Performance with Database Response Time
Response time analysis correlates time spent on query execution with end-user impact.
Response time is defined as the sum of the actual query processing time plus time spent waiting on resource availability, such as log file or wait events and types. For example, when a session tries to access the CPU, it is often not processing actively because it is waiting for an I/O or another operation. Using response time analysis, you can identify bottlenecks, pinpoint their root causes, and prioritize actions based on the impact that poor database performance has on end-users.
DPA collates SQL statement data every second, and ranks it based on response times. This helps you identify which SQL query to focus on.
DPA collates data points from five years to five seconds ago, and presents the results in easy-to-understand bar charts with alarms that lead to more detailed data surrounding an issue. Tuning advisors point DBAs toward problems that need immediate focus and provide clear, actionable advice.
Call us at 866.530.8100
Email us at DpaSales@SolarWinds.com