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.

If you don't know why the SQL server is busy or when what happened and why, Sentry One can help.

Above all, it is important to be able to carry out analyses for past problems. Because only if the past can be analysed precisely is there a chance of avoiding it in the future.

PRO:

+ Overview

+ Jump to Top SQL" analysis

+ Monitoring of limit values, very good specifications e.g. CPU 30 min > 90% Review collected by and hosted on G2.com.

CONS:

- Costs relatively high

- Calendar display and filter options are cumbersome and outdated Review collected by and hosted on G2.com.

The most useful part with the SQL solar sentry is that it is more flexible and it us designed in such way that to get the data without any comprise and it can be monitored easily wher was the issue and troubleshoot in a easy way

Scalability is the key factor with the SQL and vast and numerous data can be stored with encryption end to end wide range of data can be used here form of tables and that can be monitored high read throughput and backup system is good with the SQL comes to solar the reusable energy data can be used to build wide range of solar stations. Review collected by and hosted on G2.com.

Cons of the SQL sentry is integration part that need a skilled person to take care and also maintenance is done with highly knowledgeable person normal user cannot be able to understand how it works and what is the function of it. Review collected by and hosted on G2.com.

- It does exactly what it is advertised for

- Very easy to set up and use

- Good documentation - There are a lot of articles and videos about the software

- The GUI has a simple design and has a good usability feeling to it

- Support of VMs, on premise and cloud Review collected by and hosted on G2.com.

- A bit limited when it comes to configurating trigger actions

- Sometimes experiencing connectivity issues

- Lack of Review collected by and hosted on G2.com.

It helps me create a better visualization for the complex databases I use and helps me show connections and relationships properly. This also helps me ensure data quality, helps me generate reports, and make data exploration easier. Review collected by and hosted on G2.com.

Although it helps in automation, it does have its interface and features to learn which may require some time for becoming proficient. Review collected by and hosted on G2.com.

The real-time alerts system is very useful to keep track of what is going on with the database, and can be muted to perform maintenance or acknowledge a particular situation (so you don't get flooded with alerts). Review collected by and hosted on G2.com.

Certain parts of the user interface can be a bit hard to get used to do, and the initial configuration was slightly more complex than I thought. Review collected by and hosted on G2.com.