Item: SolarWinds Database Performance Analyzer
Rating: 8
Author: Verified User

Use Cases and Deployment Scope

We use it at the data warehousing and analytics group to monitor the load and set up alerts on the data warehouse server. We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc. Some of them are very useful, but the deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.

Pros and Cons

We have set up alerts on long-running queries, blocking other queries, deadlocks, instance availability, unused indexes, etc.
The status summary is useful to see the load on the server.
Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.

Deadlocks alert can be improved to show what queries were in the deadlock, so we can improve our solution.
We never got to setup https using the documentation provided by solar winds. We still keep getting https error when we access our DPA site.
A better technical customer service would help.

Return on Investment

It helps us monitor our server which is very useful.

Alternatives Considered

We selected SolarWinds Database Performance Analyzer to be able to monitor our database server.

Other Software Used

Redgate SQL Compare, GitHub, Redgate SQL Data Compare

Likelihood to Recommend

It is good to set up alerts on the database server. some of the alerts described in previous answers can be improved. Help on setup can be improved. As described earlier, we still do not have our DPA site set up with the security certificate and customer service did not help much.

Products Replaced

No

Key Differentiators

Price
Product Features
Product Usability
Product Reputation
Prior Experience with the Product
Vendor Reputation
Third-party Reviews

Users and Roles

8 - Database developers and architect

Support Headcount Required

1

Business Processes Supported

Query performance advice
long running query alerts
query blocking alerts
deadlock alerts

Innovative Uses

improve application performance
improve server availability

Future Planned Uses

monitor data server performance and availability

Likelihood to Renew

9

Evaluation Lessons Learned

We evaluated Redgate and Found solarwinds to be better

Implementation Rating

10

Very satisfied

Implementation Details / Implementation Partner

Implemented in-house

Implementation Phases

No

Change Management Lessons

Change management was a minor issue with the implementation

Implementation Issues

enabling secure website posed some issues. Installation was smooth

Training Types Used

no training

Pros	Cons
Quick Resolution Good followup Knowledgeable team Problems get solved Kept well informed No escalation required Immediate help available Support understands my problem Support cares about my success Quick Initial Response	None

Pros	Cons
Like to use Relatively simple Easy to use Technical support not required Well integrated Consistent Quick to learn Convenient Feel confident using Familiar	None