dbForge SQL Tools vs. SolarWinds Database Performance Analyzer

dbForge SQL Complete is well suited for professionals that have to write code all day. In my role in the business intelligence department we are writing SQL pretty much all day. Having a tool that helps us do that faster, in a cleaner way is pretty awesome and something that pays for itself quickly.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

This is an easy 10 because I actually have recommended this product to multiple clients and colleagues! Any shop that writes its own SQL queries will benefit from the insight provided by SolarWinds Database Performance Analyzer, so they know which of their queries is causing a bottleneck. Small shops or databases with only a few tables likely will see far fewer opportunities for optimization.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• SQL complete allows you to create custom snippets that allow you to store frequently ran queries in shortcuts. The code can be populated within seconds!
• Another great benefit is custom aliases. If you frequently reference the same tables over and over again it gets tiresome to retype the aliases. Storing these can make your code more consistent and save time.
• SQL complete will also highlight the metadata within your database. For example, if you start typing an insert statement you populate code for all the field names by pressing the tab. This is a real-time saver for wide tables!

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Maintains historical SQL execution data, enabling forensic analysis
• Has the ability to slice and dice the data so that you can drill down to the execution of a single SQL statement being executed by a stored procedure
• Alerts to when the consumption pattern changes
• Shows historical average run times against the current, illustrating problems when they arise
• Provides tuning advice based on best practices

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Sometimes it can be slow to retrieve the database metadata.
• Updating the software with the activation/deactivation of licenses could be further streamlined.

Incentivized

Invited by the Vendor

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Alerts seem to be lacking in DPA compared to competitor's tools. They can be setup but are not quite as easy or as helpful as some other tools I have used.
• Grooming/pruning the repository database isn't very easy. We don't manage a lot of instances but our repo DB has grown pretty significantly.
• At times when I am drilled-down to a chart, it can be difficult to navigate around from that point to another time range/query/metric.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

We have relied on this product for a very long time and it continues to exceed expectations. The product is a vital part of our organization at this point, it would not be very ideal for us to abandon it. We use it almost every day and depend on its alerts for critical parts of our business

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

I don't want to think about managing clusters of SQL servers in the future without this tool. We have demoed other tools and SolarWinds Database Performance Analyzer is the gold standard for usability and insight into what your servers are doing. The UI is a bit dated, but everything is laid out in a logical manner and drilling down into queries or timeslices is extremely intuitive.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. TR verified that a representative sample of customers was invited. More Info

I have had to use their support on a few occasions, for reasons that I am not clear about until recently I have always had problems upgrading the software (although the last 2 updates have gone without issue which I am very pleased to say). On those unfortunate occasions, the support has been brilliant with either excellently documented guides on how to resolve the issue by myself or have been hands-on with calls and screen sharing to remotely fix the issue. Every time the problem was sorted and more importantly, nothing was lost (apart from a bit of time). And as I stated above whatever the problem was that was causing my upgrade issues appears to have been resolved in the last 2 updates.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

Follow the guidelines for the capacity of the servers. We found that the DPA databases were getting rather large and also that there are ways to reduce their size built into some of the options.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

I am very satisfied after using this tool. It is a full-stack tool that includes rich features that can be customized set of functionality as per your need. by using this tool:-

• Increased our productivity rate.
• Provides speed up your development work so you can focus on other stuff.

At the time, we found SolarWinds Database Performance Analyzer to be easier to setup and to have a richer feature set than Redgate SQL Monitor, plus, from what I remember, the DPA pricing worked better for us over the course of a year. We're very happy with all the features DPA has to offer.

Incentivized

Invited by TrustRadius (TR) on Vendor's Behalf

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• Spending less time trying to figure out how tables are related thanks to the navigational help in dbForge SQL Complete, which means fixing issues takes less time.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info

• It has allowed us to progress as an organization with much less reliance on a direct DBA than would traditionally be required
• Allowed us to be much more proactive in our performance monitoring and responding to issues that would affect users.

Incentivized

Independently Invited by TrustRadius

A de minimis incentive was given to thank the reviewer for their time. The incentive was not used to bias or drive a particular response, nor was the incentive contingent on a positive endorsement. More Info