Item: SolarWinds Database Performance Analyzer
Rating: 9
Author: Mohit Tiwari

Overall Satisfaction with SolarWinds Database Performance Analyzer

Use Cases and Deployment Scope

Monitoring databases is always a critical topic for a database administrator, but SolarWinds Database Performance Analyzer made is easy with real-time monitoring for DB status using query's hash, CPU time, programs, database query plans. Users, as well there other machines for correlation DB integration in multiple databases, query analyzer helps to display the historical graphs for understanding the behavior and provide reports complete for first glance understanding of abnormal or normal statuses.

Pros and Cons

Pros

Multiple database real-time performance/status in single windows with an easy illustration using graphs.
Query analyzer and identify plan text.
Overall database status monitoring and reporting.

Cons

Plan hash and plan adviser.
DB color and grouping for interdependent query's relation.
Point the users and identify single users for multiple DB Access Scenarios.

Return on Investment

SolarWinds help DB administrators and make it easy to monitor multiple database scenarios.
Just a single inspection is required for overall monitoring of user and impact of query's in correlated database integration.

Alternatives Considered

IBM QRadar and openSUSE KIWI

All other vendors have specific expertise and no other. SolarWinds support provides overall environment device (multiple devices from the network, VM, servers, gateway devices, application) in a single window.

Likelihood to Recommend

Well suited for database real-time status and performance monitoring and reporting, an easy illustration of a query in graphs for user understanding, interdependency and query identification and a single glass view for multiple different databases.

Not as good for failed jobs status for a database, identifying a single user while it's using multiple database correlations or logging into multiple databases. The Adviser plan and suggestions are not always helpful to the administrator in relation to the alerts or abnormal behavior.

Comments

Please log in to join the conversation

SolarWind's products make IT infrastructures work better