Database Observability Pros and Cons

Best part it the central thing where you can make one master and slave mapping between the two Dpa application servers.

The graphs and minute level of monitoring is only doable from DPA otherwise we can do the monitoring from SAM Module also but will not get the same level of experience from it. Review collected by and hosted on G2.com.

It has got limited licenses per app server. I can have my 400 database servers polled from a single Dpa App server. Review collected by and hosted on G2.com.

The key feature that has accelerated our internal debugging of user reported issues is the ability to drill down to the timeframe the user reported issues and identify where the issue existed then work with our internal teams to resolve the service and query that is causing user experience issues. Review collected by and hosted on G2.com.

the reporting and email reporting navigation could be better. allowing for opening items in new tabs in an easier way. Review collected by and hosted on G2.com.

Simple to set up with command line, powershell module makes it easier for adding targets, managing them, conditions are directly exported. You just need to create yours additionally. Variety of actions, using powershell as an action is a big plus. Review collected by and hosted on G2.com.

There is a room for improvement of performance monitoring

Sometimes, checking top sql can be complicated, just because of the gui. Review collected by and hosted on G2.com.

Its simply a set it and forget it. Gives us timely information so we can remediate issues as they have occured. Also provides a insight of the health of the DB structure. Review collected by and hosted on G2.com.

With the fields were more customizable. Also some of the analytics wish had more customizable features as well Review collected by and hosted on G2.com.

SentryOne is solid performance monitoring tool, helps me get right into the problem Review collected by and hosted on G2.com.

Support i think has gone down in past couple years, it doesn't use to be like when there were an independent company. Review collected by and hosted on G2.com.

DPA is absolutely essential for any business using SQL Servers.

It has tools that help you quickly determine the root cause of issues of what happened at a certain time as it keeps a history.

It features a great alert system as well for when something is going wrong.

We often use it to analyze over 60 production databases.

It can assist in providing possible solutions on indexes for some problematic queries.

All of the above is easy to use and quick to get.

Customer support is fantastic and their personnel has only been helpful when I needed them. Review collected by and hosted on G2.com.

It is not useful to analyze an immediate occurring problem as you have to wait a bit till the data is logged and displayed. Review collected by and hosted on G2.com.

I am very good at monitoring SQL Server. I can improve the efficiency of my database by keeping track of my progress in real time. For me it was how simple it was to replace the panels and use overall. Finding and fixing speed issues is made much easier with our systems enhanced notifications. By conducting thorough study and providing detailed reports, I was able to enhance query performance and optimise resource utilisation with my databases. Review collected by and hosted on G2.com.

For me as a new user, setting up more advanced features might take some longer. I feel that the price is way too high for me and other individuals and small companies but the features are like tasty donuts. Review collected by and hosted on G2.com.

You can easily find pain points, when some reports or quesryes are delayed, automate notidication of threshold Review collected by and hosted on G2.com.

by the time in use I couldnt find any beside not being too granular for user layout Review collected by and hosted on G2.com.

Ability to easily drill down from high level alert/warnings to detailed information about performance slowness culprits Review collected by and hosted on G2.com.

Volume of data presented can make it hard to focus on high/critical issues vs low priority issues. Review collected by and hosted on G2.com.

SQL Sentry is truly one centralized solution where you can monitor all SQL server performance, issues, logs, and reports.

The performance metrics SQL Sentry provide is not just bar graph like the other tools display, it is calculated value that shows the true status of the SQL server.

When there is an issue to troubleshoot such as deadlock, you don't need another tool to get the plan or script to analyze, all required information is on one screen. Review collected by and hosted on G2.com.

Sometimes, when there is a WMI issue, it stops working and doesn't get refreshed even after WMI issue is fixed.

It would be better to add refresh button on the server level. Review collected by and hosted on G2.com.