DbVisualizer vs. SolarWinds SQL Sentry

Well suited for medium size to large Oracle system that includes a large and complex database schema with many database objects including functions and triggers. Also well suited for a medium size to large Microsoft SQL Server system with many complex database objects. Its SQL editor and query builder are well suited in developing complex SQL queries.

Of all the tools I've used, SolarWinds SQL Sentry's Top Query has been the single most helpful tool in helping me identify which queries are putting a load on our servers and at what times. This greatly simplifies my job in prioritizing tuning. Having Plan Explorer directly linked to the tool is icing on the cake.

Incentivized

• Provides simple access to all tables, indexes, views, triggers, stored procedures, etc., to just about every database on the market
• Allows me to develop and run queries in a simple, easy to read and understand manner
• Allows me to create entire new schemas as well as alter existing schemas
• Gives me access to databases without the need to install specific drivers for any particular database

Incentivized

• Alerting is very flexible and configurable to our needs
• Linking alerting into third party alerting tools via PowerShell was easy
• Collecting and rolling up SQL statements make it much easier to troubleshoot performance problems
• Drilling into PLE and what’s happening when it drops out
• Ease of drilling into time-frame to figure out what was the issue at that time
• Being able to query the SentryOne database for management reports is awesome (Deadlocks and Blocking)

• does not handle lost connections well (specially after stopping a running query) (mysql). eg. after hitting stop, and then hitting run again, it can sometimes look like its running the query, but it isn't actually!
• filtering on databases window is clunky (why the need for filtering certain object types at a time? just filter everything, google style)
• altering table, adding columns (NOT to the end of the table's columns, but earlier) is not supported (mysql) even though the db supports it (alter table add column BEFORE..)

Incentivized

• It would be nice if the reports can be interactive like drill down, clickable content, etc.
• Navigation could improve and become more intuitive.
• Calendar of events could also improve - wish the date and time range could be specified instead of just by day or interval.

Incentivized

We never had problems with it. It is able to connect to all data sources (Oracle, Informix, DB2, SQL Server) that we currently use.

Incentivized

Absolutely. SQL Sentry is an absolute must have for any company with a SQL Server estate. It provides a force multiplier to effectively manage SQL Server, and the feature sets are second to none. The support and expertise at SentryOne is incredible. They are very supportive of both the platform users and helping your business with the product

Incentivized

I use this tool for several hours each day, spanning many years in various projects. It's wide support for various database types while keeping consistency within the UI for each is important when working with various databases day in and day out.

I don't know how we survived before without this tool, the added value that you get from it to do deep dive performance analysis, reactive problem solving and proactive monitoring and alerting is limitless. We have only scratched the surface of what we can do with this tool at my company. The support and ROI that SentryOne provide is exceptional and one of my favourite vendors to deal with.

Incentivized

The system is working perfectly in capturing data, but we do experience issues with SQL Timeout when viewing results in the remote clients. This may be due to the fact that our monitoring service is consuming most of the CPU, and it is the same server that is hosting the SQL Repository. We could probably fix the issue by separating the SQL instance from the monitoring service.

Incentivized

In most cases the pages load very quickly. In our particular case, we need to do some movement of services to separate our monitoring service to separate infrastructure from the repository. When we first started with SQL Sentry on 5 licenses, we did not have any issues. Since we have now grown that to 25, we are experiencing some challenges. We do not believe this to be a tool problem

Incentivized

Never used

Incentivized

The main platform is very well supported. Requests for help with customizing alerts and monitors have been rapidly and thoroughly responded to. Our use of the chain feature seems to be out of the ordinary and our defect reports there while understood and taken seriously, tend to be lower priority than defects in the main platform. They will work diligently to give us a workaround but correction in the standard release is a little slower in the chain feature.

Incentivized

sql sentry expert came onsight to review the performance of installation and gave us a good insight to using the tool

Incentivized

Was suggested that we install the process monitors on a dev or qa database server, but we found it more useful to create an IT db server and put it there (along with a few other apps that we use for monitoring).

Incentivized

[DbVisualizer] is pretty easy to use compared to IntelliJ because of it's simplicity. The performance is very good, it feels as good as a native application compared to the other two softwares I used for the same purpose. It's very cheaper compared to the other two tools and that's a big selling point.

Incentivized

SQL Sentry has a LOT more information in it than the SolarWinds DPA product. Its reporting tool isn't as good either. The IDERA product isn't as reliable as SQL Sentry and its reporting isn't nearly as good. The IDERA UI is a resource hog and isn't as intuitive.

Incentivized

We are running 25 instances through a single monitoring service and it is able to keep up. We are finding that this many instances in our environment is about as many as can be handled. We will need to deploy additional monitoring services. Luckily, there is no additional licensing costs to deploy additional monitoring services. For us, it's just an additional Azure VM.

Incentivized

• The only point I could potentially give is hours saved by having so many warehouses hooked up in one place vs. having to manage connection string changes/password updates across multiple applications... maybe 10% decrease in time spent managing connections? Mind you, I've had everything hooked up on DbVis for close to 6 years so it's hard to remember the "before times"

• Better customer service as it alerts me automatically to loss of service issues so I can react and either get things fixed before it impacts the customers or to let my management know as soon as possible
• It helps me find expensive SQL so our customers get better performance and we make better use of our resources

Incentivized